nofilenamed
New Member
Ok I searched through many different places unfortunately it might be easier to ask,I have to select some data then set salary to increase by 10 percent where my criteria is on another table this is my code\[code\] Select E.Lastname, E.Salary, J.EEO1Classification from Employee as E Join JobTitle as J on E.JobTitleID = J.JobTitleID Update Employee set Salary = (Salary * .10) + Salary where [JobTitle.EEO1Classification] = 'Office/Clerical'\[/code\]Where am I going wrong?