I have one interesting problem that I don't know how to resolve.

I need to create a view for one of the tables that should do the

following:

The query returns 3 colums.

X Y Z

- - -

A1 A2 1

A1 A2 3

A1 A2 5

B1 B2 2

B1 B2 3

B1 B2 8

I need to show them as

A1 A2 1,3,5

B1 B2 2,3,8

I tried various combinations but couldn't make it work.

If anyone can give me a clue, I will appreciate it very much.

Thanks.