Deleting Records

[thebign]

I have two tables (same data but slightly different attribute structure) with a one-to-one relationship (the join field is "ID"). There are 69 matching records in these tables. How can I delete these matching records from table A, while leaving them alone in table B?

I'm confused because I brought both tables into a select query, created a join from ID to ID (within in the query's design view), and then added all fields from table A to the query. I then ran the select query and saw the 69 records from table A in the query's data view that I wanted to delete, highlighted all records and clicked delete. However, this action deleted the 69 matching records from TABLE B, not Table A!!! How is this possible? What should I do instead? Thanks.

 

[thebign]

Thanks for the info, Pat. However, there is no relationship at all between these two tables (other than what I created in the query's design view). Neither is a parent or child table.

I've tried using a delete query to delete the matching records in Table A, but I can't figure out how to specify the criteria (the "WHERE" clause). Really, the only criteria I have is that I want to delete the records in Table A whose "ID" attribute also exists in Table B. I'm just lost because this seems like it should be such a simple task. Thanks for your advice.