2022/1/25 20:03:26 其他 字数 682 阅读 632 来源 http://www.bubuko.com/infolist-5-1.html
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' ...
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 = ‘净含量‘))
原文：https://www.cnblogs.com/jingcx/p/12550800.html
如果您也喜欢它,动动您的小指点个赞吧
除非注明，文章均由 laddyq.com 整理发布，欢迎转载。
转载请注明：
链接：http://laddyq.com
来源：laddyq.com
著作权归作者所有。商业转载请联系作者获得授权，非商业转载请注明出处。
602392714
清零编程群