Delete Query based on the results of another query

D

DBsolutions

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.
Click to expand...

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

John W. Vinson[MVP]
 
Top