On Jan 4, 2011, at 4:50 PM, Dan Cech wrote: > Rob, > > This is demonstrating 2 special cases which will work properly: > > 1. no rows for a parent in one of the child tables > 2. 1 row for a parent in both child tables > > If you run your child inserts again to create more rows you'll end up with a > count of 4 instead of 2 in the 3rd row.
Ah yes... there it is. I knew there was a reason I don't remember doing two counts in one query before. Thanks for the free lesson! ;) _______________________________________________ New York PHP Users Group Community Talk Mailing List http://lists.nyphp.org/mailman/listinfo/talk http://www.nyphp.org/Show-Participation
