Delete Query based on the results of another query

G

Guest

I need to use a delete query to delete records from a table based on the
results of a find unmatched query. I have read in the unmatched query and
related it to the table. The select query will extract the records I need,
but the delete query will not delete the record. Is there a way to make this
happen.
 
J

John Vinson

I need to use a delete query to delete records from a table based on the
results of a find unmatched query. I have read in the unmatched query and
related it to the table. The select query will extract the records I need,
but the delete query will not delete the record. Is there a way to make this
happen.

Please post the SQL of your unmatched query and the delete query.

John W. Vinson[MVP]
 

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

Top