A
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?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
tables. The tables do not have matching records. Any ideas?
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
query that deletes all the information from multiple-----Original Message-----
I am not being successful when trying to write a delete
tables. The tables do not have matching records. Any ideas?
T
tom
Try separate Delete Queries for each table and run them consecutively.
HTH.
Tom.
HTH.
Tom.
J
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.