22,209
社区成员
发帖
与我相关
我的任务
分享
SELECT CC_CRK_GSID,CC_WLBM_CPBH,CC_WLBM_PCH,CC_WLBM_PM,CC_WLBM_GGXH
,CC_WLBM_DJ,CC_WLBM_PP,CC_WLBM_KZ
,ISNULL(CAST(SUM(TJ_QCRK.CC_JTMX_SJSL) AS VARCHAR)+'$'
+CAST(SUM(TJ_QCRK.CC_JTMX_SJSL*CC_WLBM_JZ) AS VARCHAR),'0$0') AS QCRKS
FROM V_CC_TJ_KHHW TJ
LEFT JOIN
V_CC_TJ_KHHW TJ_QCRK
ON (TJ_QCRK.CC_CRK_GSID=TJ.CC_CRK_GSID
AND TJ_QCRK.CC_WLBM_CPBH=TJ.CC_WLBM_CPBH
AND TJ_QCRK.CC_WLBM_PCH=TJ.CC_WLBM_PCH
AND TJ_QCRK.CC_WLBM_PM=TJ.CC_WLBM_PM
AND TJ_QCRK.CC_WLBM_GGXH=TJ.CC_WLBM_GGXH
AND TJ_QCRK.CC_WLBM_DJ=TJ.CC_WLBM_DJ
AND TJ_QCRK.CC_WLBM_PP=TJ.CC_WLBM_PP
AND TJ_QCRK.CC_WLBM_KZ=TJ.CC_WLBM_KZ
AND TJ_QCRK.CC_CRK_GSID=18
AND DATEDIFF(D,'2010-11-01',TJ_QCRK.RKSJ)<0
)
WHERE CC_CRK_GSID=18 AND 1=1
GROUP BY CC_CRK_GSID,CC_WLBM_CPBH,CC_WLBM_PCH,CC_WLBM_PM,
CC_WLBM_GGXH,CC_WLBM_DJ,CC_WLBM_PP,CC_WLBM_KZ