Unable to use LIMIT delete in mysql join query between multiple tables

Question

Here is my SQL query: DELETEgurFROMgroup_mastergmJOINgroup_usersguONgu.group_id=gm.idJOINgroup_user_rolesgurONgur.group_user_id=gu.idWHEREgm.school_code=14741359ANDgm.ayid=3LIMIT1; I get an error saying there is a syntax error near LIMIT. I found one here

P粉166675898 · Answer

Only single tableDELETE supports LIMIT.

Use the query as a SELECT with LIMIT and get the ID of the row (remember - LIMIT without ORDER BY is a lottery). Then delete the corresponding rows from the other copy of the table.

DELETE group_user_roles 
FROM group_user_roles 
JOIN (SELECT gur.id
      FROM group_master gm
      JOIN group_users gu ON gu.group_id=gm.id
      JOIN group_user_roles gur ON gur.group_user_id=gu.id
      WHERE gm.school_code = 14741359 AND gm.ayid=3
      /* ORDER BY ??? */ LIMIT 1
      ) USING (id)

Replace id with the primary key or unique column/expression of the group_user_roles table.