Oracle连表更新需要子查询

update lims_ordtask lo
set lo.cnas = ‘1‘
where exists (select 1
from lims_folders f
where lo.foldersid = f.foldersid
and f.folderno in (‘NJ2020MS0095‘,
‘NJ2020MS0094‘,
‘NJ2020MS0093‘,
‘NJ2020MS0092‘,
‘NJ2020MS0091‘,
‘NJ2020MS0090‘,
‘NJ2020MS0089‘)
and (lo.testno = ‘色泽‘ or lo.testno = ‘滋味、气味‘ or
lo.testno = ‘组织状态‘ or lo.testno = ‘净含量‘))

Oracle连表更新需要子查询

原文：https://www.cnblogs.com/jingcx/p/12550800.html