title: Update postgresql table with values from another table
body: <p>Let's say I have table <code>table1</code> with columns <code>id</code>, <code>value</code> and <code>table2</code> with columns <code>table1_id</code>, <code>value</code>.</p>
  
  <p>How would I write Postgresql query to update <code>table1.value</code> (whole table, not just one row) with <code>table2.value</code> if they are matching on <code>table1.id = table2.table1_id</code>?</p>
  
  <p>Thank you for answers in advance!</p>