title: update multiple rows with joins
body: <p>I have this query in postgresql:</p>
  
  <pre><code>select *
  from A s
  join B m on (s.id=m.id)
  where m.key=4 and s.ran=some_input_from_user
  </code></pre>
  
  <p>This gives me all the rows that I need to update.</p>
  
  <p>I want to set <code>A.value</code> to be <code>90</code> for all these rows.</p>
  
  <p>It doesn't look like a standart update query</p>
  
  <p>if I do...</p>
  
  <pre><code>Update A set value=90 where..... 
  </code></pre>
  
  <p>then I can't do the join.</p>
  
  <p>any ideas how to do it?</p>