I like "less magic" - you can update table alias:

UPDATE

P

SET

ProductName = N.ProductName,

Price = N.Price

FROM

dbo.Product P

INNER JOIN

dbo.New_Prices N ON P.ID = N.ID;

This is great when you join "Product" table more than once.