select BIGTYPE,CARTYPE,STATUS_ID,SALETYPE, sum(qty1) 数量1,sum(qty2) 数量2, sum(qty3) 数量3
from
(
select BIGTYPE,CARTYPE,STATUS_ID,SALETYPE,数量1 qty1,0 qty2,0 qty3
from 表一
union all
select BIGTYPE,CARTYPE,STATUS_ID,SALETYPE,0,数量2,0
from 表二
union all
select BIGTYPE,CARTYPE,STATUS_ID,SALETYPE,0,0,数量3
from 表三
)
group by BIGTYPE,CARTYPE,STATUS_ID,SALETYPE
from
(
select BIGTYPE,CARTYPE,STATUS_ID,SALETYPE,数量1 qty1,0 qty2,0 qty3
from 表一
union all
select BIGTYPE,CARTYPE,STATUS_ID,SALETYPE,0,数量2,0
from 表二
union all
select BIGTYPE,CARTYPE,STATUS_ID,SALETYPE,0,0,数量3
from 表三
)
group by BIGTYPE,CARTYPE,STATUS_ID,SALETYPE
如果表的数量不定,为n 呢??谢谢。
创建一个存放表名的表
在该表上写一个触发器,如果增加或者删除某项
利用动态sql创建视图