G
Guest
Hi,
I have 2 tables (table A and table B). Table B contains 100 records. Table A
contains 50 records. All 50 records from table A are in table B. I want to
create a delete query that will delete all the 50 common records from Table
B. I have created a query with both tables joined by a common field in both
tables. When I create the delete query and run it, I get an error message
saying that I need to spicify the table containing the records that I want to
delete. Any help?
I have 2 tables (table A and table B). Table B contains 100 records. Table A
contains 50 records. All 50 records from table A are in table B. I want to
create a delete query that will delete all the 50 common records from Table
B. I have created a query with both tables joined by a common field in both
tables. When I create the delete query and run it, I get an error message
saying that I need to spicify the table containing the records that I want to
delete. Any help?