mysql错误:Column ‘id’ in field list is ambiguous的解决方法
列’ID’在字段列表中重复,其实就是两张表有相同的字段,但是使用时表字段的名称前没有加表名,导致指代不明
如 前面加上前缀就没问题了。
SELECT
parentId,
Id
FROM
parentmenu
RIGHT JOIN (
USER
INNER JOIN relationshiprolesmenu
ON user.roleId = relationshiprolesmenu.roleId
)
ON parentmenu.Id = relationshiprolesmenu.Id
WHERE user.userId = 1
**
#####上面就是有问题表示Id指代不明,在下面添加上归属表名就可以解决了
**
SELECT
parentmenu.parentId,
parentmenu.Id
FROM
parentmenu
RIGHT JOIN (
USER
INNER JOIN relationshiprolesmenu
ON user.roleId = relationshiprolesmenu.roleId
)
ON parentmenu.Id = relationshiprolesmenu.Id
WHERE user.userId = 1