Archives of the TeradataForum

Message Posted: Wed, 18 Jun 2014 @ 23:21:36 GMT

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

Ouch, this is a mixture between old style join in WHERE plus newer JOIN syntax, I really don't know about the processing rules for that.

You should tell your user to rewrite it using JOIN syntax, maybe he just forgot the join condition accidentally, but he's the only one to know what it's supposed to return. And he should double check if it's the expected result, as Explain shows two outer joins while the source code has three, so one was automatically changed to an inner join (the optimizer is quite smart in that case).

Dieter

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