Delete query based on another query

G

Guest

I have two tables which should contain the same information. If one table is
updated and a record removed, i want to create a query that deletes the
record from the other table as well.

I have created a query which compares the primary keys of two tables and
finds those records that are required to be deleted. How can i create a
query to automatically delete these records. When i create a new delete
query based on this initial query, i get the error "Could not delete from
specified tables". Is it possible to even do what i want?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query: Could not delete from specified tables 0
delete query - could not delete from specified table 4
Parsing a table 1
Problem with Delete query! *5122008 2
Delete Query -- QUESTION 1
Bizzare delete query problem 15
Compare 2 tables and delete from one of them 2
"Read Only" Query 0

Top