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,