Re: Help Please . . .

How about this.

SELECT	ded.col_1, ded.col_2, ded.col_3, ded.col_4, cop.col_5
FROM		tablename ded,
		tablename cop
WHERE	ded.col_1 = cop.col_1 AND
		ded.col_2 = cop.col_2 AND
		ded.col_3 = cop.col_3 AND
		ded.col_6 = 'DED' AND
		cop.col_6 = 'COP';

Cheers,
Rich
--
Rich Goldkamp, Consultant
Digital Consulting & Software Services, Inc. rjgoldka_at_dcss.com

JCEdleman <jcedleman_at_aol.com> wrote in article <19990330112129.03884.00000092_at_ng20.aol.com>...
> Hi,
>
> This might be sort of a newbie question, but I have to ask it just the
same . .
> .
>
>
> Here is an example of my data from a select . . .
>
> col_1 col_2 col_3 col_4 col_5 col_6
>
> X Y Z 20 NULL DED
> X Y Z NULL 30 COP
>
> I need to return 1 row with col_4 and col_5 on one line .Obviously, col_4
and
> col_5 are based on the value in col_6. I think I can use a "decode" some
how,
> but I am not sure. Below is how I would Like it to look . . . .
>
> col_1 col_2 col_3 col_4 col_5 col_6
>
> X Y Z 20 30 (display not
needed)
>
> Can anyone help me on this?
> Thank you.
>
>
>
>
Received on Tue Mar 30 1999 - 12:22:11 CST