The MS SQL syntax is different from the MySQL syntax (MS SQL allows you to do a join).
UPDATE updatefrom p, updateto pp
SET pp.last_name = p.last_name
WHERE pp.visid = p.id
There is one post tagged update.
The MS SQL syntax is different from the MySQL syntax (MS SQL allows you to do a join).
UPDATE updatefrom p, updateto pp
SET pp.last_name = p.last_name
WHERE pp.visid = p.id