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
sql
There is one post tagged sql.
There is one post tagged sql.
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