sqlserver 联查更新 

  update [CutterStates] set DeviceGroupId  = (
  select mdg.DeviceGroupId from Machines m
  join MachineDeviceGroups mdg on m.id = mdg.MachineId
  where m.id = MachineId
  ) where CutterUsedStatus = 3

 

posted @ 2020-06-05 11:17  扶我起来我还要敲  阅读(279)  评论(0)  编辑  收藏  举报