UPDATE th_quarterly_attendance_statistics tq
LEFT JOIN th_department td ON tq.department_id_one = td.id
SET tq.department_type = td.department_type
左关联查询修改
最新推荐文章于 2024-05-21 21:16:37 发布
UPDATE th_quarterly_attendance_statistics tq
LEFT JOIN th_department td ON tq.department_id_one = td.id
SET tq.department_type = td.department_type