Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Outer Join
From:   Pramod Sadalage


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
A.ac1 = B.bc1 (+)
A.ac1 = C.cc1 (+)
B.bc2 > 10 (+)
C.cc2 =11(+)

how would I write this is teradata sql


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020