>Todd,
>Make second join and 'inner' join.
>Also moving " and child.location = 'MAIN'" to where would work but having that in join sounds better to me.
>Cetin

moving the = 'MAIN' to the where clause fixed it. It still sounds better to have it in the join condition, but at this moment, it works, I'm gonna run with it. :-)

Thanks for your help and all the hard work by Vlad!