Tuesday, July 15, 2014

SQL - Update Statement from Join

UPDATE    p
SET       p.phone_ext = d.phone
FROM      people p
JOIN      directory d
ON        p.last_name = d.last_name


Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)