title: #1054 - Unknown column '***' in 'field list'
body: <p>im trying to set up my databases within PHPMyadmin, and I keep getting this error with this specific table after I set up the foreign keys. My other two tables setup fine. I am pulling my hair out with this as I cant figure out at all what the problem is.</p>
  
  <p>The error I get when I try to insert a table within phpmyadmin is:</p>
  
  <p>SQL query: </p>
  
  <pre><code>SELECT  `customerID` ,  `instrumentID` 
  FROM  `project`.`customer` 
  ORDER BY  `customer`.`instrumentID`
  </code></pre>
  
  <p>MySQL said: </p>
  
  <pre><code>#1054 - Unknown column 'instrumentID' in 'field list' 
  </code></pre>
  
  <p><code>InstrumentID</code> is the primary key. </p>
  
  <p>Has anyone any idea what the problem is? Thanks very much in advance. If you any specific info then please ask and Ill deliver it as im not sure what other info will be needed.</p>