UPDATE SET FROM WHERE 续-优快云博客

本文介绍了一个简洁的SQL方法，通过WITH子句和JOIN操作来更新SOTracking表中的InDate、EditDate和OperateDate字段，特别适用于处理特定SONumber的操作。文章深入分析了SQL查询的细节，并提供了清晰的代码示例，帮助开发者理解和实现类似的数据更新任务。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

UPDATE  B
SET B.InDate=a.InDate,B.EditDate=A.EditDate,B.OperateDate=A.OperateDate
FROM (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.SONumber
WHERE   Operation=60


-------------------------------------------------------------------------------------------


;with so_date as
(
SELECT InDate,EditDate,OperateDate,SONumber FROM  SOTracking WITH(NOLOCK)  
WHERE  operation=130 and SONumber  in(111,222,333)
)

UPDATE A
SET A.InDate=t.InDate,A.EditDate=t.EditDate,A.OperateDate=t.OperateDate
FROM so_date AS T  INNER JOIN SOTracking as A ON A.SONumber=t.SONumber
WHERE A.Operation=60