Archives of the TeradataForum

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

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

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

how would I write this is teradata sql

Pramod

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