Search code examples
sqlinner-join

SQL inner-join query

I'm trying to make a inner-join, but I can get it to work. This is my sql query

SELECT highscore.score, bruger.brugerNavn FROM highscore INNER JOIN bruger ON highscore.brugerID ON bruger.brugerID ORDER BY score DESC

I end up with this error

SELECT highscore.score, bruger.brugerNavn FROM highscore INNER JOIN bruger ON highscore.brugerID ON bruger.brugerID LIMIT 0, 25
#1064 - There is an error in the SQL syntax near 'ON bruger.brugerID LIMIT 0, 25' at line 1

I would appreciate any help:)

Solution

  • Try this first:

    SELECT h.score, b.brugerNavn 
FROM highscore as h
JOIN bruger as b ON h.brugerID = b.brugerID

    I usually add aliases for easier handling.