How to join two ID columns with another table in MySQL?

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