Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 05 Oct 2003 @ 15:10:58 GMT


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


Subj:   Outer Join
 
From:   Pramod Sadalage

Hi,

I'm pretty new to Teradata and am having some outer join trouble.

Here is the situation.

Table A ( ac1, ac2)
Table B (bc1,bc2,bc3)
Table C (cc1,cc2,cc3)

ac1 = bc1 = cc1.

So I want to write a select which joins all these tables and returns the results from table A even if rows exist or not in table b or c. with some conditions on the columns of Table B and Table C.

An example using sql in Oracle would be

  Select A.ac1,A.ac2 from A, B, C
Where
A.ac1 = B.bc1 (+)
And
A.ac1 = C.cc1 (+)
And
B.bc2 > 10 (+)
And
C.cc2 =11(+)
 



how would I write this is teradata sql


Pramod



     
  <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: 15 Jun 2023