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
mysql
There are 2 posts tagged mysql (this is page 1 of 2).
There are 2 posts tagged mysql (this is page 1 of 2).
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