php - 内部连接错误

Question

出于某种原因，我的 INNER JOIN 有问题，它根本不起作用。

这是我的代码

SELECT
    `hold`.`id` AS `id`,
`hold`.`name` AS `name`
INNER JOIN `instruktorer`
ON `hold`.`ins` = `instruktorer`.`id`
FROM `hold`

我得到的错误是:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INNER JOIN `instruktorer` ON `hold`.`ins` = `instruktorer`.`id` FROM `hold`' at line 4

我几乎每天都进行 INNER JOIN，但现在我无法让它工作。

希望有人能帮助我

Answer 1

试试这个:

SELECT
    `hold`.`id` AS `id`,
`hold`.`name` AS `name`
FROM `hold`
INNER JOIN `instruktorer`
ON `hold`.`ins` = `instruktorer`.`id`