title: SQL order multiple data rows without combining the rows
body: <p>For a notification system, I am trying to take multiple rows of completely seperate data, and order them using a unix time stamp.  The data from each row is selected by using a users USERID, and then the rows should be ordered from the time they occured.</p>
  
  <p>for example, one of the tables being selected would be:</p>
  
  <pre><code>- USERID   msgid    timestamp
  -   3        5       1234567
  </code></pre>
  
  <p>A final table after selecting all relevant data should look like:</p>
  
  <pre><code>- USERID    msgid    postid    playerpostid     friendrequestid     timestamp  
  -   3         5                                                      1234567
  -   3                  5                                             1234566
  -   3        1234                                                    1234565
  -   3                               542                              1234564
  </code></pre>
  
  <p>As you can see, the tables all combine, but the only thing connecting them is the USERID, and ordered by the timestamp.</p>
  
  <p>Ive tried joins, unfortunately that multiples the results to a ridiculous amount of results.</p>