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