Subject | Concatenated fields |
---|---|
Author | pcpower099 |
Post date | 2010-01-21T19:01Z |
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.
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.