>>I have a master table that holds the name and ID for each entity in the database. The child tables (about 10) hold all of the information about each entity. I want to perform 1 query and retrieve all of the information about every matching entity and what table that information came from. Is this last part possible?
>>thanks
>
>If I follow, you could do something like
>
>c1="child1"
>c2="child2"
>
>SELECT M.ID, M.name, c1 + "-" + ch1.field1 AS info1, c2 + "-" + ch2.field1 AS info2 ;
>FROM Master M, child1 ch1, child2 ch2 ;
>WHERE M.ID = ch1.ID AND M.ID = ch2.ID
>
>This will give you busy data though
>
>do you have common columns? are you planning on using a UNION?
>If you don't have common columns, then you'll know where the info came from by which column number it's in.
>
>HTH

Thank you, I do not have any common columns, but I think that your sugestion will work. Unfortunalely, I am trying to piece together several departements that have never worked together before so everything is a jumble.