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

(sorry, forgot the group-by)

---------- Original Message -----------
From: "unordained" <unordained_00@...>

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

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