Perform updates with joins

You can use update to join columns when the columns being joined have the same or compatible datatypes.

This is an example that joins columns from the titles and publishers tables, doubling the price of all books published in California.
update titles 
  set price = price * 2 
  from titles, publishers 
  where titles.pub_id = publishers.pub_id 
  and publishers.state = "CA"
Parent topic: Change Existing Data