title: how to sql join/merge
body: <p>I have two tables and I would like to update a field from table 2 to table 1.  Ideas?</p>
  
  <pre><code>/*Table 1:*/
  
  
  id | name| adress| type
  --+------+--------+----
  1 | jill | 1 main | 444
  2 | bill | 2 main | 888
  
  
  
  /*Table 2:*/
  
  
  type_id | type
  --------+-------
  444     | green 
  888     | blue 
  
  
  
  /******GOAL*****/
  
  id | name| adress| type
  --+------+--------+----
  1 | jill | 1 main | green
  2 | bill | 2 main | blue
  </code></pre>
  
  <p>I want to replace the contents of table 1/column 'type' with contents of table2/column 'type.'</p>
  
  <p>Thanks folks!!</p>