I have two tables
I'm trying to increase the salaries of people in the works table by 10% based on if they work for a specific CompanyName (i,e, maybe First bank or Chase)
What I have is:
I'm getting the error #1093 - You can't specify target table 'Works' for update in FROM clause
Perhaps my approach is incorrect, im a newbie at SQL and have never done anything like this before
Putting these to one side, the following is an approach that works for SQL Server, so you might be able to modify it for the MySQL dialect without too much trouble.
answered Oct 30, 2016 at 08:12 PM