Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Unique syntax in sql {oj...}
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016