17,377
社区成员
发帖
与我相关
我的任务
分享
select * from (select tbM.SFID, count(tbMzjz.JE),sum(tbMzjz.JE),count(tbZyzj.JE),sum(tbZyzj.JE),count(tbTempJz.JE),sum(tbTempJz.JE) from tbM
left join tbMzjz on tbM.SFID = tbMzjz.SFID
left join tbZyzj on tbM.SFID = tbZyzj.SFID
left join tbTempJz on tbM.SFID = tbTempJz.SFID
group by tbM.sfid order by tbM.SFID) tab, tbM where tab.sfid = tbM.SFID
----------------------------------------------------------------------------
1 1 100 1 1000 1 yyq_address1
2 1 200 1 2000 2 yyq_address2
3 1 300 0 3 yyq_address3
4 1 400 0 4 yyq_address4
5 1 500 0 5 yyq_address5
SELECT T1.address, T1.RS, T2.JinE, T2.RS, T3.JinE, T3.RS, T4.JE, T4.RS
FROM
(SELECT address,COUNT(*) RS FROM tbM GROUP BY address) T1,
(SELECT b.address,count(*) RS,sum(a.je) JinE FROM tbMzjz a,tbM b WHERE a.sfid = b.sfid GROUP BY b.address) T2,
(SELECT b.address,count(*) RS,sum(a.je) JinE FROM tbZyjz a,tbM b WHERE a.sfid = b.sfid GROUP BY b.address) T3,
(SELECT b.address,count(*) RS,sum(a.je) JinE FROM tbTempjz a,tbM b WHERE a.sfid = b.sfid GROUP BY b.address) T4
WHERE T1.address = T2.address AND T1.address = T3.address AND T1.address = T4.address