Correction:
select parent.keyid, parent.field1, ..., parent.fieldN, count(
child1.*) Kount1, count(
child2.*) Kount2 from parent left join child1 on parent.keyid = child1.parent_id left join child2 on parent.keyid = child2.parent_id where somefilterhere group by parent.keyid
Mark McCasland
Midlothian, TX USA