1\将A表字段(金额)值全部相加 je1
2\将B表字段(金额)值全部相加 je2
3\je1-je2sql :
select (je1-je2 ) JE from ( select sum(jine) je1 from A union all select sum(jine) je2 from B)这语句是这么写的么?
2\将B表字段(金额)值全部相加 je2
3\je1-je2sql :
select (je1-je2 ) JE from ( select sum(jine) je1 from A union all select sum(jine) je2 from B)这语句是这么写的么?
from
( select sum(jine) je1,0 as je2 from A union all select 0 as je1 sum(jine) je2 from B) as tmp