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
左关联查询修改
最新推荐文章于 2023-04-07 11:15:31 发布
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