How to join the result of a query as a string into another field.

[pspk]

Hi All.

I have a peculiar requirement. There is a materials table that has multiple names for the same material id. (due to some need)

I have a query (group by) on materials table that runs fine and the result is as follows :

MatID, MatName

M123 Valves
M123 Valves X


M123 Valves Y

Now, i need to get only 1 MatID, the three MatName horizontally in two fields on maybe another table (to be later exported to excel)

ex: M123 Valves,Valves X, Valves Y
Z435 Pins1,Pins1.2, Pins2

so and so forth.

Hope I am clear. I need a solution asap.

Any help appreciated.

[pbaldy]

http://allenbrowne.com/func-concat.html