[Skunkworks] SQL Help

7 Nov 2012

      Hello,

I have a query that generates records in this form.

1   A   0   0
1   0    B  0
1   0    0   C
2   E   0   0
2   0    F  0
2   0    0  G

I want the records in the following format.

1 A  B  C
2 E  F  G

The query doesn't have an aggregate function (eg SUM, COUNT etc) so i can't
GROUP BY.

Anyone please :)

Regards,

julianne anyim