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]
这个语句应该怎么写,如果不想去掉*的话。
"F"."id" 给个别名 "fid"
SELECT thinkphp., rownum AS numrow FROM
(SELECT "U"."","F"."id" "fid" FROM "user" "U" LEFT JOIN "usergroup" "F" ON "F"."uid"="U"."id" WHERE "U"."id" = 1)thinkphp