(MySQL) Tabellen verknüpfen mit UPDATE?

[Fabian H.]

Mhh, irgendwie geht es doch noch nicht:

Fehler

SQL-Befehl :

UPDATE groups INNER JOIN users ON groups.name = users.group SET users.groupadmin = 1 WHERE users.name = groups.admin

MySQL meldet:

You have an error in your SQL syntax near 'INNER  JOIN users ON groups.name = users.group SET users.groupadmin = 1 WHERE ' at line 1

mach ich was falsch?

Gruss Fabian