SQL - Multiple clauses on JOIN?

Question

Let me post my database structures first. Table: monsterdata - http://prntscr.com/92eet Table: user_team - http://prntscr.com/92eef

I want data in user_team(m1,m2,m3,m4,m5,m6) to be matched with monsterdata.id so that I can retrieve other info. What I managed to do was retrieve only one data

    SELECT * FROM monsterdata LEFT JOIN user_team ON monsterdata.id=user_team.m1

But what I really want to do is, to include m2,m3,m4,m5,m6 to monsterdata.id=user_team.X

This might be silly but I'm more silly not to figure how to do this. Thanks for the help!

Answer 1

    SELECT * 
    FROM monsterdata LEFT JOIN user_team 
    ON monsterdata.id=user_team.m1 AND/OR 
    monsterdata.id=user_team.m2 AND/OR ...

There you go!