sql关联更新

UPDATE base_build_le_shan AS a
INNER JOIN (
SELECT
SERIAL_NO,
ID
FROM
base_land_le_shan
) AS b ON a.SERIAL_NO = b.SERIAL_NO
SET a.LAND_ID = b.ID