Query question

  • Thread starter Thread starter john
  • Start date Start date
J

john

I have table A which is linked 1xM to table B. I would like to pull out all
table A's records that have no corresponding record in table B. How can I do
this?
thanks,
john
 
Use the query wizard to create an UnMatch Record Query, to display all the
records in table A that has no corresponding records in table B
 
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

Filter suggestions in form 4
ID number and foreign key 8
Design question (normalization versus practical) 21
Record-Locking remains open after closing 0
Query by DOB 1
Issue with arrays 5
Query design 0
Query from three tables, problem when adding a record 1

Back
Top