使用内部连接获取错误

Question

我的疑问

$con=mysqli_query($sql,"(SELECT  Church Name, Class, Student Name, Mark FROM Church_details INNER JOIN Class_details ON Church_details.Church id=Class_details.Church id GROUP BY Class ORDER BY Student Name)")

我会犯这样的错误：

   You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'id=Class_details.Church id GROUP BY Class ORDER BY Student Name)' at line 1

Answer 1

SELECT  Church Name, Class, Student Name, Mark 
FROM Church_details INNER JOIN Class_details 
ON Church_details.Church id=Class_details.Church id 
GROUP BY Class 
ORDER BY Student Name)")

部分

ON Church_details.Church id=Class_details.Church id

你用了一个空间做教堂的证件..。这个表真的有一个带空格的列名吗？如果是这样的话，你应该像这样键入它

Church_details.[Church Id]

我打赌这个表的列是Church_Id

Answer 2

字段中不能有空格。我建议你看看是否可能是Church_id而不是“教堂身份”。同样适用于Student_name