SQL Inner-Join查询

Question

我正在尝试进行内部加入，但我可以使它起作用。 这是我的SQL查询

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

，我最终会出现此错误，

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

我将感谢任何帮助:)

Answer 1

首先尝试一下：

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

我通常会添加别名，以更轻松地处理。

Answer 2

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

Answer 3

你也这样尝试

SELECT highscore.score, bruger.brugerNavn 
FROM Highscore as highscore
INNER JOIN Bruger as burger ON highscore.brugerID = bruger.brugerID 
ORDER BY highscore.score desc

Answer 4

您需要在bg.brugerid上替换hs.brugerid用hs.brugerid = bg.brugerid在内部加入下

SELECT HS.score, BG.brugerNavn 
FROM highscore as HS
INNER JOIN bruger as BG ON HS.brugerID = BG.brugerID 
ORDER BY highscore.score DESC