no records in the "many" table

[Boo]

I have a table with people names "one".
I have another table with the people's children's names "many".
I would like to get a list of all the people who do not have any children.
I other words, I would like a query to show all the records in the people table who have not had any records added in the children table for them.

When I query both tables, the query only shows the records from the "one" table that has associated records in the "many" table.
I want to show the records in the "one" table that have no records in the "many" table.


Thanks

 

[pbaldy]

Try the unmatched query wizard.

 

[Boo]

Duh. How could I miss something so easy?
thanks