Archives of the TeradataForum

Message Posted: Thu, 19 Jan 2006 @ 11:12:11 GMT

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

Dear Vijay

The Where clause is applied to the answer set as a whole.

Whereas the AND makes the clause applied only to the rows returned as part of the INNER JOIN.

The best way to think of this is consider the WHere clause being applied after all the data as been returned

Regards Sheila Pynegar

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