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
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