A joined delete?

[McNugget]

How could I delete rows from say.. 3 tables that are linked..

I can join them in a SELECT with no problem, but I have no idea how i'd delete em..

tables:
thread - threadID
topic - topicthreadID
reply - replythreadID

that's how i wanted them linked, thanks if you can help!

 

[IFELSETHEN]

Don't think that ACCESS can do a JOIN Delete. Other databases have methods to do this. You could create a trigger to delete the rows from the other table.

 

[McNugget]

Yeah.. that's the thing I've thought of .. but it'd be a lot easier to do this with one single command.

Damnit. ^_^
Thanks though.