How to clean out multiple tables with one Query?

[Rkelly101]

Is their a way to edit the following query so that it will delete from more than one table?

DELETE FROM tblSample

Or do I need to write a seperate query for each table I want to delete?

 

[KeithG]

Are the other tables releated to this one? If so do you have cascade deletes inforced?

 

[Rkelly101]

Some are related but others arnt related. I was hoping I could get away with writing one command to clean out the selected tables from the database.

 

[KeithG]

you could create multiple queries and use a macro of VBA to run them all

 

[mhartman]

Hello:

How about the below solution. It works better!

http://support.microsoft.com/kb/210307/en-us

Regards
Mark