title: Select Two different values from the same column in MySQL and show results
body: <p>I have the following data:</p>
  
  <pre><code>id  pointValue  datetime
  620 0           1-2-15 13:33
  621 1           2-2-15 13:33
  622 2           3-2-15 13:33
  623 3           4-2-15 13:33
  </code></pre>
  
  <p>I need to create a SQL query when id=620 and id=623 and get the following:</p>
  
  <pre><code>id1 pointValue1 datetime1       id2 pointValue2 datetime2
  620 0           1-2-15 13:33    623 3           4-2-15 13:33
  </code></pre>
  
  <p>What I really want to do is to combine both result set in a simple row. I have tried with </p>
  
  <blockquote>
    <p>SELECT MPV.id, MPV.pointValue
    FROM pointvalues AS MPV WHERE MPV.id = "620"<br>
    UNION<br>
    SELECT MPV.id, MPV.pointValue 
    FROM pointvalues AS MPV WHERE MPV.id = "629"' </p>
  </blockquote>
  
  <p>but this gives me different rows and I need just one.  </p>
  
  <p>Thanks in advanced,
  Izaskun</p>