I beg your pardon. I already asked the same question more than a year ago. But I couldn´t do it in Firebird 1.5+. I read that it could be done with the newer LIST function.
Should I migrate to 2.1? or is there any workaround for this issue in 1.5?

Marcelo.

--- In firebird-support@yahoogroups.com, "pcpower099" <mmartinez@...> wrote:
>
> 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.
>