Archives of the TeradataForum

Message Posted: Thu, 25 Mar 2004 @ 17:26:12 GMT

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

Just a quick thought. You might try a UNION instead of going through hoops with case statements and derived tables.

SELECT col1a
FROM  "a" join conditions here
UNION
SELECT col1b
FROM "b" join conditions here

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