摘要:
UPDATE BSET B.InDate=a.InDate,B.EditDate=A.EditDate,B.OperateDate=A.OperateDateFROM (SELECT T.InDate,T.EditDate,T.OperateDate,T.SONumber FROM SOTracking AS T WITH(NOLOCK) WHERE T.operation=130 and T.SONumber in(111,222,333)) AS A INNER JOIN SOTracking AS B ON B.SONumber=a.SONumbe... 阅读全文