Archives of the TeradataForum

Message Posted: Wed, 07 Oct 2009 @ 12:35:59 GMT

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

<-- Anonymously Posted: Wednesday, October 07, 2009 08:30 -->

Try split and recombine, something like

     (SELECT ... FROM TableA
         INNER JOIN TableB ON TableA.Colx = TableB.Colx AND TableA.Colx = DefaultValue)

     UNION ALL

     (SELECT ... FROM TableA
         INNER JOIN TableB ON TableA.Colx = TableB.Colx AND TableA.Colx <> DefaultValue)

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