Parent Records Don't Show When Children Records = 0

J

Jonathan Mulder

I'm trying to make query that shows ALL records in
a "Parent" table, even when the "Parent" record has no
linked "Child" records. As soon as I insert the "Child"
table, the query shows only those "Parent" records for
which there is at least one "Child" record linked to it.
In my case, I have a table of "property parcels".
Many of the parcels have multiple "water delivery"
records. But some "property parcels" have NO "water
delivery" records.
It's probably real simple but I just don't see it.
Thanks for any suggestions!

Jonathan Mulder California Department of Water Resources
 
G

Gerald Stanley

The query designer defaults to INNER JOIN. Where you wish
to make an OUTER JOIN, you need to right click on the join
line between the two tables and specify the particular join
details in the window that appears.

Hope This Helps
Gerald Stanley MCSD
 

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

Insert records in Parent and child tables 5
delete parent records where child fields are blank 2
build up columns from multiple records 3
Using Multiple Fields to Find Unmatched Records 5
Query of changes to parent or child 1
Parameter query to select multiple child records on the same field 2
Query structure and distinct 7
Searching for parent in child-parent table 5

Top