列前缀 'whhl..xsfpyk' 与查询中所用的表名或别名不匹配。

-- =*的SQL2000以前的版本支持，之后版本不支持最好用right join
在from 表  as 别名加上
INSERT  INTO Aj_fp_xs_csh
        ( 
         rq1_
        ,rq2_
        ,rq_
        ,cz_
        ,pm_
        ,gg_
        ,cd_
        ,dj_
        ,wsdj_
        ,je_
        ,sl2_
        ,sl_
        ,dw_
        ,nsje_
        ,zyh_
        ,zbh_
        ,hthm_
        ,tdh_
        ,dwmc_
        ,fgs_
        ,bmmc_
        ,bz_
        ,ck_
        ,dqh_
        ,dwdm_
        ,rkdh_
        ,xslb
        ,htfphm_
        ,jsfs_
        ,kplb_
        ,gfdb_
        )
        SELECT  DISTINCT
                ISNULL(a.fhRQ_, a.RQ_)
               ,ISNULL(a.fhRQ_, a.RQ_)
               ,a.RQ_
               ,a.CZ_
               ,a.PM_
               ,a.GG_
               ,a.CD_
               ,a.DJ_
               ,a.DJ_ / 1.17
               ,a.JE_ - ISNULL(b.JE_, 0)
               ,ISNULL(a.SL2OK, a.SL2_)
                - ISNULL(b.SL2_, 0)
               ,0
               ,'吨'
               ,0
               ,a.zyh_
               ,a.ZBH_
               ,a.HTFPHM_
               ,a.FPHM_
               ,a.DWMC_1
               ,a.FGS_
               ,a.BMMC_
               ,a.bz_
               ,a.CK_
               ,( SELECT    dqh
                  FROM      dwtx
                  WHERE     dwmc = a.dwmc_1
                )
               ,( SELECT    dwdm
                  FROM      dwtx
                  WHERE     dwmc = a.dwmc_1
                )
               ,a.RKDH_
               ,a.XZ_
               ,a.HTFPHM_
               ,a.JSFS_
               ,a.KPLB_
               ,a.GFDB_
        FROM    whhl..V_XSFPMX AS a
RIGHT JOIN whhl..V_XSFPYK AS b ON b.fphm_=a.fphm_ AND b.xh_=a.a.xh_