Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 02 Oct 2002 @ 17:43:12 GMT

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

Subj:   Re: Left join problem
From:   John Grace


What happens if you change the left outer join to an inner join? do you get 113,217 rows? Do you have any other filters in the where clause? A filter in the where clause can "shut off" outer joins, because the Where clause step is performed first. You should be able to see this in the Explain, basically something gets filters prior to the outer join operation. Try moving the "where" clause joins into the "From" clause and I think you will a different answer (I don't know if it is correct, just different.) If you need to see SQL let me know and I can provide an example.

John Grace

  <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: 15 Jun 2023