title: MySQL Query with join and Alias without table name
body: <p>i encountered a funny problem:</p>
  
  <p>I have two table t1 and t2 with several columns. Because two columns in the both tables have the same name, i need to to this:</p>
  
  <pre><code>SELECT t1.foo AS ID, t2.bar as NAME
  FROM t1, t2
  WHERE t1.foo = t2.foo;
  </code></pre>
  
  <p>The Answers are headed with t1.ID, t2.NAME</p>
  
  <p>I don´t wont the table names in the headlines.</p>
  
  <p>Funny thing: Using the same query in a view returns the correct / wanted headings: ID...NAME</p>
  
  <p>I want to use those queries in stored procedures where the same behaviour has been observed.</p>
  
  <p>Tried with MySQL 5.5.9</p>
  
  <p>Any idea how to avoid the table names in the headlines?</p>