Archives of the TeradataForum

Message Posted: Tue, 15 Aug 2006 @ 12:13:18 GMT


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

Subj:		Re: Request for help in converting the below query

From:		nithya.r

Query:

It should test for the condition clm_disp_cd = 'READJ' only when there are duplicate adjustment number for the same claim line i.e.

Pratheesh,

You should use a Qualify clause along with union statement.

Thanks,


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

Archives

2006 Indexes

Last Modified: 15 Jun 2023