Nicos wrote:
> Hello,
> i have a table (Matches) than have the columns listed below:
> matchId, homeTeam, awayTeam, result
>
> I want to list all the teams DISTINCT both home and away teams.
> How do i do that?
>
> Best regards,
> Nicos

Are you looking for something like:

SELECT homeTeam FROM matches
UNION
SELECT awayTeam FROM tmatches