title: MySQL -- SELECT Command denied to user
body: <p>This is a syntax error i am positive ...  However I am banging my head as to 'why'.  I have searched all "like" questions here on SO and they all (mostly) address a user with wrong permissions .. I assure you this isn't the case.</p>
  
  <p>This  is my Query:</p>
  
  <pre><code>use database;    # I am using workbench .. I use this so I don't have to database.table  
  
  SELECT firstname
  FROM user, user_role
  LEFT JOIN user.uid ON user_role.uid
  
  WHERE user.firstname LIKE '%zak%';
  </code></pre>
  
  <p>The exact error is </p>
  
  <pre><code>Error Code: 1142. SELECT command denied to user '###'@'##.##.##.##' for table 'uid' 0.197 sec
  </code></pre>
  
  <p>I am not looking for a TABLE called <code>uid</code> ..  I am looking for the FIELD <code>iud</code>.</p>
  
  <p>I have truncated the statement down to this portion that's causing the error .. There are other fields and other tables .. But I simply can't <code>JOIN</code>.</p>
  
  <p>Is is a logical error with the location of the <code>.</code> for field identification?</p>