MYSQL and Delete

[Anon]

I'm trying to Delete some rows in a database, but the delete is based on the values in another

Delete from Reminder where UserID=1 and ((Reminder.EventID=Events.RecordID) and (Events.GroupID=10001))

So basically I want to delete all the reminders where the USERID=1 and they have a reminder linked to the event 10001?

But it don't like this - and I can't use a sub-select in mySQL?

Please help 🙂 (I'm still learning this mySQL stuff!)

Mat

[[deleted]]

use a select to get the reminder.eventid for all records in the events table that have groupid=10001.

Contactenate all those eventid's into one big comma seperated list like this:
(1,2,3,4)

then use that in your DELETE statement:L

DELETE FROM Reminder WHERE EventID IN $string_of_ids;

so the query ends up like this:

DELETE FROM Reminder WHERE EventID IN (1,2,3,4);

[Anon]

Thanks, I was hoping it would be a one shot exercise, but I guess I need sub-select for that...