A表
PrimaryKey ForeignKey AMoney
5 53212 173250.0000
B表
PrimaryKey ForeignKey AMoney
1 53212 10.0000
2 53212 13.0000
SELECT isnull(A.AMoney,0)AMoney,isnull(B.BMoney,0) BMoney FROM
(SELECT ForeignKey,SUM(AMoney) AMoney FROM A表 GROUP BY ForeignKey) ALEFT JOIN
(SELECT ForeignKey,SUM(BMoney) BMoney FROM B表 GROUP BY ForeignKey) B
ON A.ForeignKey=B.ForeignKey
结果:
AMoney BMoney
346500.0000 23.0000