Delete Query

[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?

 

[Rick Brandt]

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?

Did you specify a table in the grid portion of the query designer? It is not
enough to just create the join. You have to pull something down from the
desired table into the grid.

 

[Hunter57]

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?

If you post the SQL of your query in this thread it will make it much
easier to get the help you need. : )

Hunter57