Help Please . . .

From: JCEdleman <jcedleman_at_aol.com>
Date: 30 Mar 1999 16:21:29 GMT
Message-ID: <19990330112129.03884.00000092@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 - 10:21:29 CST