MySQL INNER JOIN query issue

Question

I have created an INNER JOIN query as shown below and was wondering how I can make it work? I need for the HomeTeam and AwayTeam to equal TeamID in the query. Any help would be much appreciated. Thanks

$result = mysqli_query($con,"SELECT results.*,team.TeamName 
                             FROM results 
                                INNER JOIN team ON team.TeamID = results.HomeTeam 
                                INNER JOIN team on team.TeamID = results.AwayTeam");

Well with sort of thing we need to know where we want to go and from where we need to start from... So can you put your tables in here and also a sample of what you are expecting to achieve? That would help us work something out. — TimBrownlaw
– TimBrownlaw, Commented Oct 17, 2016 at 13:40

jeroen · Accepted Answer · 2016-10-17 13:40:39Z

4

You need to use aliases for the table that you are including twice. Otherwise mysql cannot distinguish between the two.

To be able to process the results easily, you can do the same with the names you are selecting.

Something like:

SELECT 
    results.*, 
    t1.TeamName AS TeamNameHome,
    t2.TeamName AS TeamNameAway
FROM results 
INNER JOIN team t1
    ON t1.TeamID = results.HomeTeam 
INNER JOIN team t2
    ON t2.TeamID = results.AwayTeam

answered Oct 17, 2016 at 13:40

jeroen

91.8k22 gold badges117 silver badges132 bronze badges

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

1 Comment

Kyle Over a year ago

Thank you very much, I shall give this a bash!

Collectives™ on Stack Overflow

MySQL INNER JOIN query issue

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related