请教大家一个统计的怪问题，谢谢

2.JPG (123.33 KB)

3.JPG (123.87 KB)

复制内容到剪贴板

代码:

SELECT WLDW.Dw_Name AS 单位名称, WLDW.Dw_Name AS 科室名称,
      SUM(YSZK.Hw_sum) AS 应收金额, SUM(FKJL.Fk_money) AS 付款金额,
      SUM(YSZK.Hw_sum) + SUM(FKJL.Fk_money) AS 欠款金额, WLDW.root,
      WLDW.Dw_File, WLDW.Dw_Pinyin
FROM WLDW RIGHT OUTER JOIN
      YSZK ON WLDW.Dw_Id = YSZK.Dw_Id LEFT OUTER JOIN
      FKJL ON YSZK.Dj_Id = FKJL.Dj_id
GROUP BY WLDW.Dw_Name, WLDW.root, WLDW.Dw_File, WLDW.Dw_Pinyin