0

Let's say I have these tables:

Table  Persons:
ID     Name
1      John

Table  Groups:
ID     Group
1      Admin
2      Printer
3      Server

Table PersonsAndGroups:
ID     person_ID    group_ID
1      1            1
2      1            2
3      1            3

Now I want a view that will give me this result:

PersonID PersonName Groups
1        John       Admin, Printer, Server

I though of somehing like...

SELECT ID AS PersonID, Name AS PersonName, (SELECT ????) FROM Persons

... but I can't figure out the "subquery".

Any idea?

Thanks!

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
MojoDK
  • 4,410
  • 10
  • 42
  • 80

0 Answers0