Delete query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
Click to expand...
query that deletes all the information from multiple
tables. The tables do not have matching records. Any ideas?
 
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?
Click to expand...

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