SQL 多表连接统计查询

select Y_YGZLTBL.FZ,Y_YGZLTBL.GH,Y_YGZLTBL.XM,Y_YGZLTBL.YE,SUM(Y_SKTBL.KKJE),SUM(Y_CZTBL.JE) FROM (Y_YGZLTBL LEFT JOIN Y_SKTBL ON Y_YGZLTBL.GH=Y_SKTBL.GH AND (Y_SKTBL.SKSJ BETWEEN '2010-12-19 00:00' AND '2010-12-19 23:59')) RIGHT JOIN Y_CZTBL ON Y_YGZLTBL.GH=Y_CZTBL.GH  AND (Y_CZTBL.RQ BETWEEN '2010-12-19 00:00' AND '2010-12-19 23:59') GROUP BY Y_YGZLTBL.FZ,Y_YGZLTBL.GH,Y_YGZLTBL.XM,Y_YGZLTBL.YE

 

经过半小时的琢磨，在interbase 2009中测试成功以上多表连接统计查询。

信心来自于收获，喜悦来自于突破。