Delete Query

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Alexandra504 said:
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.
 
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
 
Back
Top