论坛 › SQL Server › SQL Server关联表更新数据

hc6538 发表于 2016-11-1 06:29:13

SQL Server关联表更新数据

update dbo.PriceMonitor
set SubType=p.SubType
from PriceMonitor a
inner join PriceMonitorPlus p
on p.StockId=a.StockId
where a.SubType is null

查看完整版本: SQL Server关联表更新数据