select field list ; FROM Parent ; LEFT OUTER JOIN Child1 ; ON Parent.KeyID = Child1.ForeignKeyId ; LEFT OUTER JOIN Child2 ; ON Parent.KeyID = Child2.ForeignKeyId ; WHERE whatever_filter_criteria_goes_here ; GROUP BY _goes_here ; ORDER BY _goes_hereThe LEFT OUTER JOIN gets all parent records even if it has no child records in either table. You also can not do this in the View designer. The view designer will nest the joins which will give an error later on. You can use the designer to get the initial SQL code to copy-and-paste into a PRG for editing and tweeking [and for documentation in case of disaster].