更新表字段,从另一个表中查询出来
UPDATE t
SET t.Premium = (SELECT TOP 1 Max( t2.Premium )
FROM dbo.TableName t2
WHERE t2.SetId = 2012 AND t2.Id = t.ID)
FROM dbo.TableName t
WHERE t.SetId = 2013
进QQ群 246600653 【备注当前网址】 聊聊如何精养卡提额。
UPDATE t
SET t.Premium = (SELECT TOP 1 Max( t2.Premium )
FROM dbo.TableName t2
WHERE t2.SetId = 2012 AND t2.Id = t.ID)
FROM dbo.TableName t
WHERE t.SetId = 2013