Oracle和SQL Server连接表的更新操作Update SQL 语句
For Oracle:
update ipop_worktype_loader wl set wl.status=0
where exists (select 1 from ipop_worktype_lkp w where wl.worktype_id = w.worktype_id and w.application_Id=10 and wl.status=1)
For MS SQL Server:
update wl set wl.status=0 from ipop_worktype_lkp w,ipop_worktype_loader wl
where wl.worktype_id = w.worktype_id and w.application_Id=10 and wl.status=1
update ipop_worktype_loader wl set wl.status=0
where exists (select 1 from ipop_worktype_lkp w where wl.worktype_id = w.worktype_id and w.application_Id=10 and wl.status=1)
For MS SQL Server:
update wl set wl.status=0 from ipop_worktype_lkp w,ipop_worktype_loader wl
where wl.worktype_id = w.worktype_id and w.application_Id=10 and wl.status=1
