title: Unknown column in 'field list' error on MySQL Update query
body: <p>I keep getting MySQL error #1054, when trying to perform this update query:</p>
  
  <pre><code>UPDATE MASTER_USER_PROFILE, TRAN_USER_BRANCH
  SET MASTER_USER_PROFILE.fellow=`y`
  WHERE MASTER_USER_PROFILE.USER_ID = TRAN_USER_BRANCH.USER_ID
  AND TRAN_USER_BRANCH.BRANCH_ID = 17
  </code></pre>
  
  <p>It's probably some syntax error, but I've tried using an inner join instead and other alterations, but I keep getting the same message:</p>
  
  <pre><code>Unknown column 'y' in 'field list' 
  </code></pre>