Yes, QA is best one or you can use it as code programatically using VB etc.,
let us assume you want to update price field in table A with ColX in table B, the query looks like
UPDATE TableA SET TableA.price=TableB.ColX
FROM TableA INNER JOIN TableB
ON TableA.product=TableB.product
Madhu