The following example 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"
