--- In firebird-support@yahoogroups.com, "Leyne, Sean" <Sean@...> wrote:

> Use tables aliases to include multiple references to a single table.
>
>
> SELECT
> SCHEDULE.DATE_TIME, HomeTeam.TEAM, AwayTeam.Team
> FROM SCHEDULE
> LEFT JOIN TEAMS HomeTeam ON HomeTeam.PRIMARYKEY = SCHEDULE.HOME_TEAMID
> LEFT JOIN TEAMS AwayTeam ON AwayTeam.PRIMARYKEY = SCHEDULE.AWAY_TEAMID
>
>
> Sean
>

Sean, aliases did the trick, thank you kindly!