Multiple tables in dataset.

I have a table that has a single column that contains the name of other tables. I would like to form a DataSet that has the contents of this table as well as the contents of each of the tables listed by name in this table. For example I have a table:

TableList

TableA
TableB
TableC

TableA

Key1 Description1
Key2 Description2

. . .

I am thinking something like:

SELECT * FROM (SELECT * FROM TableList)

But this doesn't work

SELECT * FROM TableA

Unfortunately, the way these table are set up, you'll have explicity determine the table.

...or you could always loop through each entry for TableList.

Adamus

|||

Would you mind giving me a sample of "looping through the table list"? I am not aware of how to code this and then return the resultant data set?

Thank you.

Kevin