Parent Records Don't Show When Children Records = 0

  • Thread starter Thread starter Jonathan Mulder
  • Start date Start date
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
 
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
 
Back
Top