涉及到多张表条件查询进行数据更新时:
1,Oracle的做法是通过子表嵌套的方式进行更新,而不是Join
update ITEM_ELECTRONICS c set c.is_use_m_s_d=0 where c.id in (
select c.id from ITEM_ELECTRONICS a
left join item b
on a.item_id=b.id
where a.is_use_m_s_d=1 and b.code like 'V-21%'
)
2,Sqlserver则可以通过Join的方式进行更新
update ITEM_ELECTRONICS a
left join item b
on a.item_id=b.id
set a.is_use_m_s_d=0
where a.is_use_m_s_d=1 and b.code like 'V-21%'