#title Update with records from another table
#author Stefan Hornburg (Racke)
#topics blog; PostgreSQL
#date 2010-07-01
#pubdate 2010-07-01T12:55:27+02:00
#lang en



<example>

update subject_cloud set count = count + 1 from (select subject from subjects where sku = '9780520241329') as subs where subs.subject = subject_cloud.subject;

</example>