分表 join 正常表问题 返回
华强 发布于2025/8/13
这段代码翻译的sql 是：
SELECT
"rt"."area_id" AS "areaid",
"d"."ap_sn" AS "apsn",
"d"."positioning_time" AS "positioningtime",
"d"."ap_change_id" AS "apchangeid"
FROM
( SELECT * FROM "history_positioning_record_2025_06_01" ) "d"
LEFT JOIN "base_ap_change_record" "rt" ON ( "d"."ap_change_id" = "rt"."id" )
WHERE
( "registration_id" = N '18944315394373' )
ORDER BY
"d"."positioning_time" DESC
不是我希望的样式：
SELECT
"rt"."area_id" AS "areaid",
"d"."ap_sn" AS "apsn",
"d"."positioning_time" AS "positioningtime",
"d"."ap_change_id" AS "apchangeid"
FROM
"history_positioning_record_2025_06_01" "d"
LEFT JOIN "base_ap_change_record" "rt" ON ( "d"."ap_change_id" = "rt"."id" )
WHERE
( "registration_id" = N'18944315394373' )
ORDER BY
"d"."positioning_time" DESC
请问一下如何解决？
热忱回答（2）
-
fate sta VIP0
2025/8/13where扔到join后面
0 回复 -
华强 VIP0
2025/8/18
好的，谢谢了
0 回复