Unbekanner Fehler in SubQuery

[faux]

Okay hat sich erübrigt.

Aus der MySQL Doku:

Zitat:

One restriction is that a subquery's outer statement must be one of: SELECT, INSERT, UPDATE, DELETE, SET, or DO. Another restriction is that currently you cannot modify a table and select from the same table in a subquery. This applies to statements such as DELETE, INSERT, REPLACE, UPDATE, and (because subqueries can be used in the SET clause) LOAD DATA INFILE.

Wie könnte ich das sonst noch in reinem SQL lösen?

Grüße
Faux