title: Select multiple table without AS (alias)?
body: <p>I need to SELECT from more than one table that has a lot of fields. Do I have to manually fabricate the query like this:</p>
  
  <pre><code>table1.field1 AS table1_field1, table1.field2 AS table1_field2, ..., table2.field1 AS table2_field1, ...
  </code></pre>
  
  <p>Or is there any workaround for this in MySQL or PHP that will automatically take care of all these when there are identical field names in the tables? </p>
  
  <p>In PHP, I tried:</p>
  
  <pre><code>$results = $conn -&gt; query("SELECT table1.*, table2.* FROM table1, table2 WHERE 1"); // $conn is a mysqli object
  $results = $results -&gt; fetch_array();
  </code></pre>
  
  <p>But if there is a field named 'title' in both of the 2 tables, $results['title'] would just contain the value of the record from the 2nd table. </p>
  
  <p>I know there are numeric indexes that you can use to access the value but:</p>
  
  <ol>
  <li>It's unreadable.</li>
  <li>You have to update the code accordingly every time the table structure such as the order of the fields changes.</li>
  </ol>
  
  <p>Any idea?</p>