注册

General error: -2112,如下SQL语句,一定需要使用*的情况下,怎么写?

网站建设 2024/06/26 411 1 已解决

SELECT thinkphp., rownum AS numrow FROM (SELECT "U"."","F"."id" FROM "user" "U" LEFT JOIN "usergroup" "F" ON "F"."uid"="U"."id" WHERE "U"."id" = 1) thinkphp

单独的
SELECT "U"."","F"."id" FROM "user" "U" LEFT JOIN "usergroup" "F" ON "F"."uid"="U"."id" WHERE "U"."id" = 1
正常显示,如果加上SELECT thinkphp.
, rownum AS numrow FROM (SELECT "U"."*","F"."id" FROM "user" "U" LEFT JOIN "usergroup" "F" ON "F"."uid"="U"."id" WHERE "U"."id" = 1) thinkphp
就报错,General error: -2112 第1 行附近出现错误: 有歧义的列名[id]

这个语句应该怎么写,如果不想去掉*的话。

回答 0
暂无回答
扫一扫
联系客服