select sum(aa)
from
(select sum(fs) as aa from table1 group by bj having bj='1'
union
select sum(fs) as aa from table2 group by bj having bj='1')
注意null
from
(select sum(fs) as aa from table1 group by bj having bj='1'
union
select sum(fs) as aa from table2 group by bj having bj='1')
注意null
select * from table1
union all
select * from table2)
group by bj having bj='1';
from
(select sum(fs) fs1,bj from table1 group by bj having bj='1'
union
select sum(fs) fs1 ,bj from table2 group by bj having bj='1'
)
group by bj
huangcaibing(Mike) 和caspling(迷糊猫) 的应该是UNION ALL,
w_tsinghua() 的完全正确!
谢谢!!
(select sum(fs) fs_sum from table1 where bj='1') a,
(select sum(fs) fs_sum from table2 where bj='1') b