>>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
>
>Are you planning to use a SELECT statement?

Hopefully.