sethbeckerman5 Staff asked 4 years ago
I have tables like below,
Match table
date
team1
team2
2/2/2019
t001
t002
3/2/2019
t007
t002
Team table
teamID
teamName
t001
ABCD
t002
EFGH
t003
IJKL
t007
MNOP
I want to display Match table with teamName of team1 and team2 instead of teamID. I know I can join it as,
But it can join with only one column. I don't know how to join both columns. Is there anyway to do this.
View on Stack Overflow