Archives of the TeradataForum

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

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

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.

Regards,

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

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