错误:您的 SQL 语法有错误;检查与您的MySQL服务器版本相对应的手册,了解要使用的正确语法


ERROR: 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

为什么当我尝试将内部连接tbl_interview_schedule tbl_reservation_info_id时,我总是收到这样的错误?

SELECT CI.*, HM.*, TP.*, RI.*, IS.*
FROM tbl_client_info AS CI
INNER JOIN tbl_reservation_info AS RI
ON RI.client_info_id = CI.client_info_id
INNER JOIN tbl_house_model AS HM
ON HM.house_model_id = RI.house_model_id
INNER JOIN tbl_type_of_payment AS TP
ON TP.type_of_payment_id = RI.type_of_payment_id
INNER JOIN tbl_interview_schedule AS IS
ON IS.reservation_info_id = RI.reservation_info_id
WHERE RI.reservationstatus = 'For Interview' AND TP.paymenttype = 'Cash'

IS是MySQL中的一个保留字。

相关文章: