如何解决访问中的此查询错误?

Question

我在 Access 中有下一个语法错误

SELECT Maestros.Nombre AS Maestro, Materias.Nombre AS Materia
FROM Maestros
INNER JOIN Maestros_Materias ON Maestros.id = Maestros_Materias.Maestro_id
INNER JOIN Materias ON Materias.id = Maestros_Materias.Materia_id
WHERE Maestros.id = 1;

我不知道这里的错误是什么。感谢您的回答

Answer 1

在 Access 中，需要嵌套括号来处理多个JOIN。

这应该这样做：

SELECT Maestros.Nombre AS Maestro, Materias.Nombre AS Materia
FROM (Maestros
INNER JOIN Maestros_Materias ON Maestros.id = Maestros_Materias.Maestro_id) 
INNER JOIN Materias ON Materias.id = Maestros_Materias.Materia_id
WHERE Maestros.id = 1;