title: update query with join on two tables
body: <p>I have <code>customer</code> and <code>address</code> tables.</p>
  
  <p>Query:</p>
  
  <pre><code>SELECT *
  FROM addresses a,
       customers b
  WHERE a.id = b.id
  </code></pre>
  
  <p>returns 474 records</p>
  
  <p>For these records, I'd like to add the <code>id</code> of <code>customer</code> table into <code>cid</code> of <code>address</code> table.</p>
  
  <p><strong>Example</strong>:
  If for the first record the id of customer is 9 and <code>id</code> of address is also 9 then i'd like to insert 9 into cid column of address table. </p>
  
  <p>I tried:</p>
  
  <pre><code>UPDATE addresses a,
         customers b
  SET a.cid = b.id
  WHERE a.id = b.id
  </code></pre>
  
  <p>but this does not seem to work. </p>