Archives of the TeradataForum

Message Posted: Tue, 05 Aug 2014 @ 23:16:00 GMT

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

<-- Anonymously Posted: Tuesday, August 05, 2014 16:59 -->

Try using the subquery as a derived table and do INNER JOIN instead of IN.

Use the sub-select to populate a volatile table, then reference the volatile table in place of the subquery (either for IN or for INNER JOIN).

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