Multiple Select statements in one query - PHP + MySQL

Question

Tables: Players: ID(PK), Name, Team, Pos

Matchups: matchupID(PK), player1ID, player2ID
player1ID and 2 are FKs to Players.ID

I'd like to select the name of both players when pulling but can't get the query correct. I do NOT want a union here.

Something along the lines of this, I'm also open to a better suggestion for formatting the two tables I have.

$queryString = "SELECT Players.name FROM Players
                    INNER JOIN Matchup WHERE Players.ID = player1ID,
                    SELECT Players.name FROM Players
                    INNER JOIN Matchup WHERE Players.ID = player2ID";

ScaisEdge · Accepted Answer · 2016-05-25 20:40:11Z

1

You shoudl join two time Player and not matchup

  $queryString = "select a.name, b.name from Matchup as c
            Inner Join Players as a on c.player1ID = a.ID
            Inner Join Players as b on c.player2ID  = b.ID";

answered May 25, 2016 at 20:40

ScaisEdge

133k10 gold badges98 silver badges111 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Multiple Select statements in one query - PHP + MySQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related