title: MySQl, join/merge 2 tables without shared column and ordering by a common column
body: <p>I have two tables with identical structures handling distinct data. I want to merge them, add a text field indicating where the data for that row came from, and order by a common field.</p>
  
  <p>TABLE1</p>
  
  <pre><code>ID|NAME|YEAR  
  
  1,'peter',2008
  2,'edward',2010
  </code></pre>
  
  <hr>
  
  <p>TABLE2</p>
  
  <pre><code>ID|NAME|YEAR
  
  1,'compadre',2009
  2,'vika',2011
  </code></pre>
  
  <hr>
  
  <p>DRAFT of query ( obviously is erroneous )</p>
  
  <pre><code>select * from TABLE1 JOIN TABLE2 order by YEAR asc
  </code></pre>
  
  <p>expected result:</p>
  
  <pre><code>1,'peter','iamfromTABLE1',2008
  1,'compadre','iamfromTABLE2',2009
  2,'edward','iamfromTABLE1',2010
  2,'vika','iamfromTABLE2',2011
  </code></pre>
  
  <p>I know I can do this using PHP/MySQL, but is there not a more elegant way like the "One Simple Query".</p>