title: SQL 2012 UPDATING column
body: <p>I'm trying to alter the employees pay using data from a separate table to determine if the employee has a specific job classification.</p>
  
  <p>It's telling me I have an invalid column name.  But the column exists.</p>
  
  <p>Any help is appreciated, while I continue to look for a solution.</p>
  
  <p>Thanks guys.</p>
  
  <pre><code>USE HARTKudlerFineFoods
  
  SELECT dbo.tblEmployee.empSalary,
         dbo.tblJobTitle.jobJobClassification
  FROM   dbo.tblEmployee
         FULL OUTER JOIN dbo.tblJobTitle
                      ON dbo.tblEmployee.empJobID = dbo.tblJobTitle.jobJobID
  
  BEGIN TRANSACTION;
  
  UPDATE dbo.tblEmployee
  SET    empSalary = empSalary * .05946
  WHERE  ( [jobJobClassification] = '%ist' ); 
  </code></pre>