Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 18 Dec 2007 @ 17:11:43 GMT

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

Subj:   Re: A question on Left Join
From:   Victor Sokovin

  I don't understand the problem. Both Teradata and Oracle return the same answers in both cases. Simple way to think of it is the WHERE is applied after the join. This means filtering on the Inner table (one that is optional) will not return a row if it does not have a match, because the value is NULL.  

Bob, the problem is described in the first posting of this thread. The filtering there was done on the *outer table*.

Later postings have confused the subject with conditions on the inner table. No issues there.

The original problem may still stand if the OP or others confirm it.


  <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