Combining variable number of fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a question and Im not sure if there even is an answer for it. I have
a database of programs. In a separate table I have a list of approvers for a
design. One row per approver. Now a design can have any number of approvers
and I want to combine there names all in one field. For example

Main table
ID | Other stuff
1
2
3

Approver table

ID | Approver
1 Jekyll
1 Hyde
1 Mark
2 John
2 Felix
3 Howard

I would like a query that went

ID | Approvers
1 Jekyll, Hyde, Mark
2 John, Felix
3 Howard
 
Back
Top