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"
Although a join can usually be done with up to 16 tables, if a join is part of an update or delete statement, the query can only refer to 15 tables.