Delete query

[Andre]

I am not being successful when trying to write a delete query that deletes all the information from multiple tables. The tables do not have matching records. Any ideas?

 

[Jason]

Andre,

I might be wrong, but I do not think you can do this from
one query. Either use one query and change what table it
is going to look at before run OR create one query for
each table and run them in order.

Jason

-----Original Message-----
I am not being successful when trying to write a delete

query that deletes all the information from multiple
tables. The tables do not have matching records. Any ideas?

 

[tom]

Try separate Delete Queries for each table and run them consecutively.

HTH.

Tom.

 

[John Vinson]

I am not being successful when trying to write a delete query that deletes all the information from multiple tables. The tables do not have matching records. Any ideas?

Run multiple delete queries, one for each table. If you don't have
relationships you can't delete from multiple tables in one query.