The following simple query produces the results below:
SELECT SCHEDULE.DATE_TIME, TEAMS.TEAM FROM SCHEDULE
LEFT JOIN TEAMS ON SCHEDULE.HOME_TEAMID=TEAMS.PRIMARYKEY
***QUERY RESULTS (Showing 'Home Team' Column)***
12/01/2012 TeamA
12/21/2012 TeamB
12/25/2012 TeamC
How do I include the
The following simple query produces the results below:
SELECT SCHEDULE.DATE_TIME, TEAMS.TEAM FROM SCHEDULE LEFT JOIN
TEAMS ON SCHEDULE.HOME_TEAMID=TEAMS.PRIMARYKEY
***QUERY RESULTS (Showing 'Home Team' Column)***
12/01/2012 TeamA
12/21/2012 TeamB
12/25/2012 TeamC
How do I include
Try using aliases:
SELECT
SCHEDULE.DATE_TIME,
HOME_TEAM.TEAM as HomeTeamName,
AWAY_TEAM.TEAM as AwayTeamName
FROM
SCHEDULE
LEFT JOIN TEAMS HOME_TEAM ON SCHEDULE.HOME_TEAMID=HOME_TEAM.PRIMARYKEY
LEFT JOIN TEAMS AWAY_TEAM ON SCHEDULE.AWAY_TEAMID=AWAY_TEAM.PRIMARYKEY
On Wed, Oct 24,
