I have one table called schedules and one teams. On the schedules table I have intTeam1 and intTeam2, however, both fields come from the same table and field Teams.teamID.
If I only use WHERE schedules.intTeam1 = Teams.teamID works only for one colum.
How can make this work?
Code:SELECT schedules.scheduleID, schedules.intTeam1, schedules.intTeam2, Teams.teamID, Teams.teamName FROM schedules, Teams WHERE schedules.intTeam1 = Teams.teamID AND schedules.intTeam2 = Teams.teamID
Any help is much appreciated,