title: Joining two tables, multiple rows into a single row different columns
body: <p>I have two tables.</p>
  <pre><code>USER
  
  USER_ID | USER_NAME
  --------------------
  659    |  John  
  660    |  Andrew 
  661    |  Bianca
  --------------------
  </code></pre>
  <pre><code>USER_ADDRESS
  
  USER_ID |TYPE |    ADDRESS
  ------------------------------
  659     | HOME |    New York
  659     | WORK |    New Jersey
  660     | HOME |    San Francisco
  660     | WORK |    Fremont
  ------------------------------
  </code></pre>
  <p>I want to join multiple records from the 2nd table into a single row on the 1st table.</p>
  <pre><code>USER_ID | USER_NAME | HOME_ADDRESS | WORK_ADDRESS 
  --------------------------------------------------
  659   |  John    |   New York      | New Jersey
  660   |  Andrew  |   San Francisco | Fremont
  </code></pre>
  <p>How do I get the above output in a select query?</p>