Archives of the TeradataForum

Message Posted: Thu, 22 Dec 2011 @ 09:09:16 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Thursday, December 22, 2011 03:23 -->

Hi Folks,

I came over this sql which although simple caught my attention because it had a syntax something like a {oj .... } as part of it. The sql is given below :

     SELECT
     A.COL1,
     B.COL2,
     C.COL3
     FROM
     { oj ((TAB1 A LEFT OUTER JOIN TAB2 B ON A.COL1 = B.COL1 )
           INNER JOIN TAB3 C ON B.COL2 = C.COL2 )
           LEFT OUTER JOIN TAB4 D ON C.COL3 = D.COL3 }
     WHERE
     A.SOMECOL = 'Active'

Does anyone know what the {oj .... } means ? this is the first time I have come across such a syntax.

Any clarification would be of great help

Thanks.

	<Prev	Next>		<<First	<Prev	Next>	Last>>