Delete Query

  • Thread starter Thread starter gr
  • Start date Start date
G

gr

Hi, to what should I set the Where critria of a Del query
if I only want to delete Records which have no
subdatasheet records?

I have one main table which has 4 subdatasheets. If there
are no records for the corresponding NameID (NameID is in
the main table) in the subtables then delete the item from
the main table.

how?
 
Delete From MainTable where MainTable.Key not in (Select Key from SubTable)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with displaying query as a 2D grid 10
Beginner SQL Query Question 7
sql statement 1
Update query help 1
Subdatasheet comes and goes 1
Delete Query: Could not delete from specified tables 0
Error when running qry! 1
making a table with a query 2

Back
Top