Posted by rai28pankaj on 07/14/06 11:02

Hi,

I have unoin of 2 queries which gives outpur as:


Service_Name P3 P4
-------------------------------------
S1 1 NULL
S2 4 NULL
S3 3 NULL
S1 NULL 5
S2 NULL 2
S3 NULL 6

I want 1 row for each Service with values in both columns like:

Service_Name P3 P4
-------------------------------------
S1 1 5
S2 4 2
S3 3 6

Can anybody please help me out?

Thanks in advance for the help

Cheers
Panky

[Back to original message]