title: MySQL Select, column with same name from multiple tables, order by another column with same name
body: <p>I'm trying to select rows with a certain column name and order them by another column name. </p>
  
  <p>Here's my problem, into N simplified tables:</p>
  
  <p><code>table 1: id, username, datetime, comment</code></p>
  
  <p><code>table 2: id, username, datetime, vote</code></p>
  
  <p>.</p>
  
  <p>.</p>
  
  <p>.</p>
  
  <p><code>table N: id, username, datetime, bought</code></p>
  
  <p>I want to be able to select all rows where <code>username='Some Name'</code>, ordered by datetime -- across all N tables. </p>
  
  <p>--</p>
  
  <p>Incidentally, does anyone know of a good book or resource on learning and practicing advanced SQL? (Tried SQLZoo, but they don't have enough advance examples.. and then there are the too-advanced ones that I'm still stumped on)</p>