基本上,我有这个查询:
SELECT *, `groups`.`goodname`
FROM students AS s
INNER JOIN groups AS g
ON s.univ_group = g.id
WHERE name LIKE "%А%"
它在查询尝试时给出此错误:#1054 - Unknown column 'groups.goodname' in 'field list'
已经尝试过'groups'.goodname, 'groups.goodname', goodname.'groups', goodname.groups
(由于 SO 标记原因,' 在这里代表 '(等等。我知道它与这些反引号有关,但我无法弄清楚它是如何工作的。谢谢!
当您将别名添加到"组"表 - "g"时,查询不再识别具有groups
名称的表,您需要使用别名,因此您需要更改 groups
.goodname
至 G. goodname
SELECT *, g.`goodname`
FROM students AS s
INNER JOIN groups AS g
ON s.univ_group = g.id
WHERE name LIKE "%А%"