select team, list(name, '/') as players from master left join slave on
slave.fkidteam = master.idteam;


---------- Original Message -----------
From: "pcpower099" <mmartinez@...>

> 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?

------- End of Original Message -------