|
|
Archives of the TeradataForum
Message Posted: Tue, 18 Dec 2007 @ 17:11:43 GMT
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.
Victor
| |