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 corresponding 'Away Team' column? Please see tables below: ***SCHEDULE TABLE*** PRIMARYKEY HOME_TEAMID AWAY_TEAMID DATE_TIME 1 1 2 12/01/2012 2 2 3 12/21/2012 3 3 1 12/25/2012 ***TEAMS TABLE*** PRIMARYKEY TEAM_NAME 1 TeamA 2 TeamB 3 TeamC Please advise, thank you!