Subject Concatenated fields
Author pcpower099
Hi All!

I have a master (teams) and a slave (players) table

say:

Master table:
IDTEAM TEAM
---------------
1 RIVER
2 BOCA
3 SAN LORENZO

Slave table:

FKIDTEAM NAME
--------------
1 CARRIZO
1 FERRARI
1 CABRAL
2 ABONDANZIERI
2 RIQUELME
3 ...

Now I want a query to have this report:

TEAM PLAYERS
--------------------------------------------------------
RIVER CARRIZO/FERRARI/CABRAL
BOCA ABONDANZIERI/RIQUELME
...

All players concatenated in a field string.

How can I do this?
Thanks in advance, Marcelo.