Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 13 Jan 2000 @ 21:53:30 GMT

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

Subj:   Re: Nested Left Joins
From:   Kenneth Stiglich

Try to create a Left outer join between the first table and the other ones.

Try with a query like that:

     Select (....)
        from (T1 Left outer Join T2 on T1.C1=T2.C1) Left outer join T3 on T1.C1=T3.C1)

I expect it will work fine.


Kenneth Stiglich M
Serv. Data WareHouse
Ingenieria de la Información

  <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