gpt4 book ai didi

mysql - 数据库查询失败 : Column 'id' in field list is ambiguous

转载 作者:太空宇宙 更新时间:2023-11-03 11:00:00 25 4
gpt4 key购买 nike

<分区>

       SELECT  realestate.id,node.id,node.name
from realestate,
(SELECT
GROUP_CONCAT(parent.name_en ORDER BY parent.lft DESC) AS name,id
FROM
address AS node JOIN address AS parent
ON node.lft BETWEEN parent.lft AND parent.rgt
WHERE node.lft >={$lft} and node.rgt <={$rgt}
GROUP BY node.name) as node
INNER JOIN users ON id_user = users.id
LEFT JOIN pic ON id_realestate = realestate.id
WHERE node.id = realestate.address_id

我尝试修改了几次,这个错误信息不会消失“数据库查询失败:字段列表中的列'id'不明确”。有什么解决办法吗?

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com