title: 1052: Column 'id' in field list is ambiguous
body: <p>I have 2 tables. <code>tbl_names</code> and <code>tbl_section</code> which has both the <code>id</code> field in them. How do I go about selecting the <code>id</code> field, because I always get this error:</p>
  
  <pre><code>1052: Column 'id' in field list is ambiguous
  </code></pre>
  
  <p>Here's my query:</p>
  
  <pre><code>SELECT id, name, section
    FROM tbl_names, tbl_section 
   WHERE tbl_names.id = tbl_section.id
  </code></pre>
  
  <p>I could just select all the fields and avoid the error. But that would be a waste in performance. What should I do?</p>