SELECT  a.rk_dwid ,
        MAX(a.rk_dw) AS dwmc ,
        YEAR(rk_date) AS rknf ,
        SUM(a.rk_spzj) AS fkje ,
        SUM(ISNULL(b.yfl_fkje,0)) AS yfje
FROM    rkd a
        LEFT OUTER JOIN ysyfjl b ON b.yfl_type = 'gys'
                                    AND b.yfl_mark = '付款'
                                    AND a.rk_dwid = b.gg_id
                                    AND YEAR(a.rk_date) = CONVERT(INT, LEFT(b.yfl_nf,4))
WHERE   a.rk_style = '正常入库'  AND a.rk_fbbj = '000'
GROUP BY a.rk_dwid , YEAR(a.rk_date)
ORDER BY dwmc , rknf

------解决方案--------------------
这样直接看怎么能看出来？

------解决方案--------------------
探讨

SQL code

SELECT  a.rk_dwid ,
        MAX(a.rk_dw) AS dwmc ,
        YEAR(rk_date) AS rknf ,
        SUM(a.rk_spzj) AS fkje ,
        SUM(ISNULL(b.yfl_fkje,0)) AS yfje
FROM    rkd a
        LE……


------解决方案--------------------
猜测：

主表和子表放一起做聚合，如果子表记录有多行，对主表的聚合是否会出现重复统计。

------解决方案--------------------
try:
SQL code
SELECT a.rk_dwid,a.rk_dw as dwmc,year(a.rk_date) as 入库年份,SUM(a.rk_spzj) as fkje,SUM(b.yfl_fkje) as yfje,SUM(a.rk_spzj)-SUM(b.yfl_fkje) as 未付金额
FROM rkd a left join ysyfjl b on a.rk_dwid=b.gg_id and YEAR(a.rk_date)=convert(int,LEFT(b.yfl_nf,4)) and b.yfl_type='gys' and b.yfl_mark='付款'
where a.rk_style='正常入库' and a.rk_fbbj='000'
group by a.rk_dwid,a.rk_dw,year(a.rk_date)