title: How can I resolve an ambiguous column name error in MySQL?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/6638520/1052-column-id-in-field-list-is-ambiguous">1052: Column &#39;id&#39; in field list is ambiguous</a>  </p>
  </blockquote>
  
  
  
  <p>I have two tables, and I want to connect the tables by <code>sb_id</code> (<code>sb_id</code> is same for two tables).  So, I used my query like this:</p>
  
  <pre><code>SELECT Name, 
         class 
    FROM student_info,
         student_class 
   WHERE id = 1 
     AND student_info.sb_id = student_class.sb_id;
  </code></pre>
  
  <p>And it's showed error:</p>
  
  <blockquote>
    <p>1052: 'id' in where clause is ambiguous </p>
  </blockquote>
  
  <p>Another thing,I want to show just a single result,by using "JOIN".</p>