SQL Server 2005 simple update statment with join
I have 2 tables, one called dbo.dd
and one called dbo.gt.
where dbo.gt.v_products_model = dbo.dd.[Vendor Stock Code]
I would like to update the
开发者_运维知识库field dbo.gt.v_products_price
with the dbo.dd.[Dealer Ex]
Sorry, forgot syntax of SQL 2005 and in a jam!
Update g
set g.v_product = d.[Dealer Ex]
From dbo.gt g
Join dbo.dd d on g.v_products_model = d.[Vendor Stock Code]
精彩评论