title: Need column values to be dispersed among multiple columns
body: <p>I have the two tables as below :</p>
  
  <p>SQL> select * from customer;</p>
  
  <pre><code>CUSTOMERID CUSTOMERNAME
  ---------- --------------
       1         A
       2         B
  </code></pre>
  
  <p>SQL> select * from cars;</p>
  
  <pre><code> CARID CUSTOMERID MODEL
  ---------- ---------- ----------
       1          1 toyota
       2          1 honda
       3          2 suzuki
  </code></pre>
  
  <p>I need to write an SQL query which would give an output like below :
  ( Can we use PIVOT or UNPIVOT for this ? I am not sure ! )</p>
  
  <pre><code>CUSTOMERID  CUSTOMERNAME    Model1     Model2
  ----------  -------------   -------   --------
       1         A            toyota     honda
       2         B            suzuki     NULL
  </code></pre>