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
Seattle Facebook, OpenSocial, and Web Development
-
Adam's Stuff
Seattle Facebook, OpenSocial, and Web Development
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
{ 0 comments… add one now }