 |
 |
Archives of the TeradataForum
Message Posted: Wed, 02 Oct 2002 @ 17:43:12 GMT
| Subj: | | Re: Left join problem |
| |
| From: | | John Grace |
Bruce
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
| |
