SQL Server 2005 simple update statment with join

Question

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!

Answer 1

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]