Archives of the TeradataForum

Message Posted: Mon, 28 Oct 2002 @ 14:43:07 GMT

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

Try this

Sel a.acct_id,b.acct_type
From a, b
Where a.acct_id = b.acct_id
and zeroifnull(a.acct_type) <>zeroifnull(b.acct_type);

- Sudarsan Thopay

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