That is what I have been trying but I keep getting weird results.
Firstly I am not familiar with the COUNT(child1.*) part. Do you mean the asterisk literally or a field name. I get a syntax error with that.
It seems that this solution works as long as a child table does not contain more than 1 record per parent. Once a child table has more than 1 record per parent many unexpected results occur.