通过数据库更新养护类型

wbv123

merge into t_ware_ext a
using  (select  * from  t_ware  ) b
on (a.wareid=b.wareid and a.compid=b.compid  and  b.warecode='101111')
when matched then
  update  set maintain_type =2   
where  compid =2  ;
merge into t_ware_ext a
using  (select  * from  t_ware  ) b
on (a.wareid=b.wareid and a.compid=b.compid  and  b.warecode='102222')
when matched then
  update  set maintain_type =2   
where  compid =2  ;




---更新养护类型
merge into t_ware_ext a
using  (select  * from  t_ware  ) b
on (a.wareid=b.wareid and a.compid=b.compid  and  b.warecode='商品编码')
when matched then
  update  set maintain_type =1   ---1 (一般养护) 2 (重点养护)
where  compid =2  ;