title: Joining SELECT of two rows with same id in SQL
body: <p>ok I do have this table</p>
  
  <pre><code>| id | first | last | type
    1     mp      de    bill
    1     mark    ve    ship
    2     dw      her   bill
    2     dwi     rra   ship
  </code></pre>
  
  <p>now I want it to be like this</p>
  
  <pre><code>| id | bill.first |  bill.last | ship.first | ship.last
     1     mp             de           mark       ve
     2     dw             her          dwi        rra
  </code></pre>
  
  <p>the main key of joining rows is by their ID is this possible?</p>
  
  <p>I tried already using group by but I don't have an idea how to use it</p>
  
  <p>and I don't know what word to use in google to search for the solution to my problem</p>
  
  <p><strong>I have only one table</strong></p>