title: MySQLIntegrityConstraintViolationException: Column 'adno' in where clause is ambiguous
body: <p>I want to get the data from two tables <code>studentinfo</code> ans <code>studentmarks</code>.</p>
  
  <p>I use <code>Join</code>s with where clause but it will show:</p>
  
  <pre><code>ConstraintViolationException: Column 'adno' in where clause is ambiguous
  </code></pre>
  
  <p>Here is my code snippet</p>
  
  <pre><code>String adno = jTextField10.getText();
  
  String s = "Select si.n,
                     si.class,
                     sm.acc,
                     sm.bst,
                     sm.eco from si Left Join sm 
                     ON si.adno = sm.adno 
  
                     where adno ='" + adno + "';";
  </code></pre>