1、修改內(nèi)聯(lián)表
update a_locationservice al,t_kxt_executor_info t
set al.objid= t.id
where al.location_id=t.end_location_id
and al.objtype='8' and al.objid is null
2、修改級(jí)聯(lián)表：
update t_kxt_executor_info_detail tid
LEFT JOIN
t_kxt_common_reports crep
on
crep.id=tid.obj_id
set tid.flag='2'
where (tid.obj_type='terminalPhotograph' or tid.obj_type='requestInfo' or tid.obj_type='terminalInfo') and crep.id is null