OUTER JOIN을 하면 에러가 납니다
왜 그럴까요? ㅠ.ㅠ
하루 종일 인터넷을 뒤져도 답이 안나옵니다
죄송한데요. 급한데.. 고수님들~~~~~~~~~~ 제발 도와 주세요
SELECT *
FROM ZTFIE0001 M , ZTFIE2003 A
WHERE A.REQ_NO = M.REQ_NO
AND M.REQ_FG ='S'
LEFT OUTER JOIN ZTFIE2004 AS B ON
A.REQ_NO = B.REQ_NO
AND A.REQ_NO ='1111111111'
----------------------------------------------------
ERROR [42601] [IBM][DB2/AIX64] SQL0104N An unexpected token "'S' LEFT OUTER JOIN ZTFIE2004 AS B" was found following "EQ_NO AND M.REQ_FG =". Expected tokens may include: "<name>". SQLSTATE=42601
|