第一問select a.jhqd_hh,result=a.aa-b.bb
from
(select jhqd_hh,sum(jhqd_jhsl) as aa from y_jhqd group by jhqd_hh)a
inner join (select xsqd_hh,sum(xsqd_xssl) as bb from y_xsqd group by xsqd_hh)b
on a.jhqd_hh=b.xsqd_hh
from
(select jhqd_hh,sum(jhqd_jhsl) as aa from y_jhqd group by jhqd_hh)a
inner join (select xsqd_hh,sum(xsqd_xssl) as bb from y_xsqd group by xsqd_hh)b
on a.jhqd_hh=b.xsqd_hh
inner join (select a.jhqd_hh,result=a.aa-b.bb from
(select jhqd_hh,sum(jhqd_jhsl) as aa from y_jhqd group by jhqd_hh)a
inner join (select xsqd_hh,sum(xsqd_xssl) as bb from y_xsqd group by xsqd_hh)b
on a.jhqd_hh=b.xsqd_hh)c
on c.cbqd_hh=c.jhqd_hh
inner join (select a.jhqd_hh,result=a.aa-b.bb from
(select jhqd_hh,sum(jhqd_jhsl) as aa from y_jhqd group by jhqd_hh)a
full join (select xsqd_hh,sum(xsqd_xssl) as bb from y_xsqd group by xsqd_hh)b
on a.jhqd_hh=b.xsqd_hh)c
on d.cbqd_hh=c.jhqd_hh
……
…… 各货总值的汇总1001+1002+1003=80+0+0=80(80是我唯一要的值)。
sql语句该怎么写?
结果
1001 -520.0 ¥
1002 0.0
1003 0.0但正确的结果应该是
1001 80.0 ¥
1002 0.0
1003 0.0
inner join (select a.jhqd_hh,result=a.aa-b.bb from
(select jhqd_hh,sum(jhqd_jhsl) as aa from y_jhqd group by jhqd_hh)a
full join (select xsqd_hh,sum(xsqd_xssl) as bb from y_xsqd group by xsqd_hh)b
on a.jhqd_hh=b.xsqd_hh)c
on d.cbqd_hh=c.jhqd_hh
=================对的,对的。
执行出来的是1001 80.000000
1002 .000000
1003 .000000我只想要1001和1002和1003的总值。sql语句怎样写?