title: how to order a mysql selection
body: <p>I'm selecting data from two different tables which have a common field "date" and i want to order by date desc but i can't get it to work and i haven't found much help googleing about it.  </p>
  
  <pre><code>SELECT table1.id, table1.date, table2.id, table2.date FROM table1, table2 ORDER BY  
  </code></pre>
  
  <p>Also i would appreciate any links to read more about these types of queries, it would save me from having to ask here for help all the time :D Thanks. </p>