MySQL can’t specify target table for update in FROM clause | VerySimple

The query is basically the same, except the inner select is wrapped inside another select. The most important thing to note is that the original select has been given an alias “tmptable“. (The name tmptable is arbitrary, you can give it any alias name.) T

verysimple.com