title: Select everything from joined tables
body: <p>I have two joined tables:</p>
  
  <pre><code>SELECT table1.*, table2.* FROM table1 t1 INNER JOIN table2 t2 ON t1.id = t2.t1_id
  </code></pre>
  
  <p>The question: In query results, id will always be taken from secondary table defined in SELECT statement?</p>
  
  <p>For example:</p>
  
  <p>if I use <code>select t1.*, t2.*</code> - in results id will be t2.id</p>
  
  <p>if I use <code>select t2.*, t1.*</code> - id will be t1.id.</p>
  
  <p>Is this good practice to use 'merged' result, or should I avoid ambiguity, and always define columns strictly?</p>