John;

You have answered your own question. There is no relationship between child tables. I do not know how you want the end result, but guess the structure of each child table is the same. I would run a seperate SQL statement against each each parent/child relationship, and combine the result sets into one set.

Tom