Archives of the TeradataForum

Message Posted: Thu, 16 Dec 2004 @ 19:07:41 GMT

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

Assuming this 'abcd' value represents a code_id column, how about a left outer join? Like...

     select A.code_id, B.code_id, case when B.code_id is not null then 'found
     it' else 'didnt find it' end
     from A
     Left Outer Join codes B
     On A.code_id = B.code_id;

--Jason

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