These posts is about ExecuteSQL and Outer Joins.
Google "outer join filemaker"
Except for the ExecuteSQL function, FileMaker does not do outer joins--which can be a real pain at times.
Thanks for the replies folks. I was hoping there would be an "idiomatic" FileMaker way to solve this problem, and dropping back into SQL wasn't exactly the solution I was looking for.
There can be ways to do this without SQL, but I recommend ExecuteSQL. Not using SQL here requires creating "dummy" records so that none of your parent records do not actually have zero child records--that can easily get very "messy" when it comes to managing your data.