不确定为什么会出现以下错误。。。无法绑定多部分标识符"OBDATE.SUMMARY_BLOCK_ID"。
这是我的加入声明。。。
LEFT OUTER JOIN
(SELECT SUMMARY_BLOCK_ID
,max(ob_dt_eddsys_dt) as [DUE_DATE]
from HSB_DATING AS OBDATE
GROUP BY SUMMARY_BLOCK_ID) AS [LATEST_DUE_DATE]
ON OBHSBV.SUMMARY_BLOCK_ID = OBDATE.SUMMARY_BLOCK_ID
对于查询的这一部分:
LEFT OUTER JOIN (
SELECT SUMMARY_BLOCK_ID , max(ob_dt_eddsys_dt) as [DUE_DATE]
FROM HSB_DATING AS OBDATE
GROUP BY SUMMARY_BLOCK_ID
) AS [LATEST_DUE_DATE]
ON OBHSBV.SUMMARY_BLOCK_ID = OBDATE.SUMMARY_BLOCK_ID
OBDATE
在外部查询中不可用。您将这个派生表命名为[LATEST_DUE_DATE]
,因此应该使用它来引用它:
ON OBHSBV.SUMMARY_BLOCK_ID = [LATEST_DUE_DATE].SUMMARY_BLOCK_ID