Avanceret Left join
-----svar gerne på dansk
-----
Hi, I need help with a LEFT JOIN statement.
I have the following at the moment:
SELECT BettingmatchTeam1ID, BettingmatchTeam2ID, BettingteamName, BettingteamName FROM Bettingmatches LEFT JOIN Bettingteams ON BettingmatchTeam1ID = BettingTeamID
It return a row like this: 1,2,Titans,Titans
I want it to return Team2's name instead of Team1s name in the statement above, so that it instead will read: 1,2,Titans,4Kings
How do I extent my statement to make that possible?
I know it can be done with subqueries but I prefer joins.
-----
svar gerne på dansk
-----
