MySQL: Update using a Left Join

UPDATE posts 
LEFT JOIN users ON users.id = posts.user_id
SET
    posts.first_name = users.first_name,
    posts.last_name = users.last_name,
    posts.email = users.email
WHERE
    users.type = 'author' AND posts.email = '';

 

Related Snippets

•	MySQL: Insert from Select