Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: I'm stumped...case logic on a left join subquery vs. case logic on a select query
From:   Swapnil Deshpande

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



  <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: 28 Jun 2020