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