Left Outer Join Syntax

From: Al Willis <alwillis_at_pdq.net>
Date: Sun, 6 May 2001 11:18:34 -0500
Message-ID: <D01501B92B222E38.987E742F8B636AE1.5E4276297474C794@lp.airnews.net>

Can someone post the equivalent Oracle SQL statement also showing the proper use of the (+)?

SELECT DISTINCT A.DATASHEET,A.REVISION FROM SCV_M A LEFT OUTER JOIN SCV_D B ON A.DATASHEET=B.DATASHEET AND A.REVISION=B.REVISION

LEFT OUTER JOIN INDX_M C ON A.TAGNUMBER = C.TAGNUMBER
LEFT OUTER JOIN INDX_M D ON A.AUXTAG1 = D.TAGNUMBER
LEFT OUTER JOIN INDX_M E ON A.AUXTAG2 = E.TAGNUMBER

LEFT OUTER JOIN CCV_M I ON B.TAG1=I.TAG1 AND B.TAG2=I.TAG2 AND B.TAG3=I.TAG3 AND B.CASENO=I.CASENO Thanks,

Al Willis Received on Sun May 06 2001 - 11:18:34 CDT