title: Postgres UPDATE statement
body: <p>I have moved from mysql to psql, but find it hard to get my head around the UPDATE statement using multiple left joins.</p>
  
  <p>How would you rewrite this in Postgres? (I am using postresql 9.4)</p>
  
  <pre><code>update task t 
      left join project p on t.project_id = p.id 
      left join client c on t.client_id = c.id 
      left join user u on t.user_id = u.id
  set t.project_name = p.name, 
       t.client_name = c.name,
       t.user_name = u.name;
  </code></pre>
  
  <p>Any pointer will be welcome.</p>