Hello Sascha, > It works for SQL Server, but MySQL doesn't like it. Seems MySQL does not > allow you to do a sub-query on the same table that you are trying to update.
I didn't realise that this was about a self-join in an update. Yes, I'm aware of this MySQL limitation. MySQL and SQLite are the only databases I know that have it. Another solution that will perform well is to create equivalent stored procedures in MySQL and SQL Server and call those with jOOQ Cheers Lukas
