Archives of the TeradataForum

Message Posted: Wed, 12 Dec 2007 @ 13:33:20 GMT

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

I think your Problem is the where clause.

I had this also many times when using a left outer join.

Usually I am isolateing the query with the where clause into a dirived table. This should give you the desired results.

Example:

     Sel  A.col1,A.col5, B.col3,B.col4
     FROM
     (
     SELECT col1,col2,col5 from A
     WHERE col1='FMS'
     ) A
     LEFT OUTER JOIN B
     ON A.col2=B.col2
     ;

As far as I know the where clause should not affect the result in your query (as described in the manuals) But I made the experince that it does.

Hope this helps.

Joerg

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