That works perfectly. I did not know that you could alias a table name
multiple times to get multiple distinct selects out of it.
Simple yet elegant. Thanks.
> Hi.
>
> Presuming you have the team names in a seperate table, you could write
> something like:
>
> SELECT home.name, away.name, winn
Hi.
Presuming you have the team names in a seperate table, you could write
something like:
SELECT home.name, away.name, winner.name
FROM games, teams AS home, teams AS away, teams AS winner
WHERE home.id = games.homeid AND
away.id = games.awayid AND
winner.id = games.winnderid A
