UPDATE b_spjk_spfzmx
SET spfzbh = AABB.fd_civilcode FROM(
SELECT
A .spsbbh,
A .spfzbh,
B.fd_civilcode
FROM
b_spjk_spfzmx A
INNER JOIN t_video_catalog_notify B ON A .spsbbh = B.fd_camera_id
) AABB WHERE b_spjk_spfzmx.spsbbh = AABB.spsbbh
UPDATE b_spjk_spfzmx
SET spfzbh = AABB.fd_civilcode FROM(
SELECT
A .spsbbh,
A .spfzbh,
B.fd_civilcode
FROM
b_spjk_spfzmx A
INNER JOIN t_video_catalog_notify B ON A .spsbbh = B.fd_camera_id
) AABB WHERE b_spjk_spfzmx.spsbbh = AABB.spsbbh