SELECT A.*, B.*
FROM SSDB A
LEFT OUTER JOIN
(SELECT A.* FROM DANMST A
WHERE A.FactoryCd='ABC'
AND A.RLDATE=(SELECT MAX(RLDATE) FROM DANMST B
WHERE B.FactoryCd='ABC'
AND B.RLDATE <='2006-02-22'
AND A.ITCD=B.ITCD)B
ON A.FactoryCd=B.FactoryCd
AND A.ITCD=B.ITCD
WHERE A.FactoryCD='ABC'
AND A.ITCD='10001'
이케 했습니다.
물론,
SELECT A.* FROM DANMST A
WHERE A.FactoryCd='ABC'
AND A.RLDATE=(SELECT MAX(RLDATE) FROM DANMST B
WHERE B.FactoryCd='ABC'
AND B.RLDATE <='2006-02-22'
AND A.ITCD=B.ITCD
요놈은 됩니다.
그런데, LEFT OUTER JOIN절에 있는 내부QUERY는 안되나요?
자알 썼는데,,MSSQL에서는여..(물론, 오라클에서도요..)
도와주세요..고수님들~~~~
|