innerJoin查询显示错误 - innerJoin query show error

innerJoin query show error

本文关键字：错误显示查询 innerJoin | 更新日期: 2023-09-27

我只打印两个表数据，所以我使用内部连接

SELECT  sd.GameName 
FROM LottoryTickets AS sd
    JOIN group AS p 
    ON sd.Group = p.groupname 
WHERE p.groupname = 11

现在我得到#106 4 - 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 'group AS p ON sd.Group = p.groupname WHERE p.groupname = 11 LIMIT 0, 30' at line 3

这个回应请引导我

感谢您的预付款。

使用：

`group` //as group is a predefined keyword

group是MySQL中的一个关键字，如果你想用这个名称调用一个表，你必须用backticks把这个名称括起来；

SELECT  sd.GameName 
FROM LottoryTickets AS sd
    JOIN `group` AS p 
    ON sd.Group = p.groupname 
WHERE p.groupname = 11

GROUP是ansi-sql保留字。eaven提交了明显的代码（组用蓝色表示）。

尝试

SELECT  sd.GameName 
FROM LottoryTickets AS sd
    JOIN `group` AS p 
    ON sd.Group = p.groupname 
WHERE p.groupname = 11