title: MySQL alias shorthand?
body: <p>I need to select all columns from two tables, but need to be able to differentiate between them in the result.</p>
  
  <p>Is there a shorthand method of giving each column in the result an alias?</p>
  
  <p>For example:</p>
  
  <pre><code>SELECT t1.* AS t1.SOMETHING
       , t2.* AS SOMETHING_ELSE 
    FROM TABLE1 
   INNER JOIN TABLE2 
      ON SOMETHING = SOMETHING_ELSE
  </code></pre>
  
  <p>In the results, all columns from table one would be prefixes t1, while all results from table two would be prefixes t2.</p>
  
  <p>Any advice appreciated.</p>
  
  <p>Thanks.</p>