Archives of the TeradataForum

Message Posted: Wed, 12 Feb 2003 @ 06:43:51 GMT

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

Hi Bruce,

I find that the query syntax is the problem. While writing left join query we can make effective use of brackets to avoid such problems. This can help us in avoiding such errors

For e.g

select *
from (((table1 left outer join table2 on (join between
table1 and table2)) left outer join
subquery on (join between any of the tables present in
previous bracket and the subquery)) left outer join
table3 on (join between any of the tables present in
previous 2 brackets and the table3));

I hope this will help

Regards,

Swapnil

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