Delete Non Matching Records

[klufkee]

Hi all,

I have two tables that are related to each other.
One has 30K records while the other has 500.
I ran a 'Without Matching' query to find records in the larger table
that didn't have a matching record in the smaller table, however now I
want to delete those records. Is there an easy way to do this?

Thanks,
Bill

[pietlinden]

turn the select query into a delete query?

[klufkee]

Great! Thanks so much. Works just fine.

(Just goes to show how much I have to learn!)

Bill

[Tim Marshall]

kl*****@hotmail.com wrote:

I have two tables that are related to each other.
One has 30K records while the other has 500.
I ran a 'Without Matching' query to find records in the larger table
that didn't have a matching record in the smaller table, however now I
want to delete those records. Is there an easy way to do this?

Bill - not a direct answer to your question, but I would refer you to
the recent "Relationships. Does anyone use them?" thread. After you've
gotten rid of your orphaned records, to avoid future occurances, set up
a relationship to enforce referential integrity between the two tables.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me