select statement with variable table name

[dv89k]

Hi all,

I have a table containing list of table name.
I want to use select statement with a variable list table name



For example:

select * from (select tableName from List)...

Is it possible?
pls help . THX

[pbaldy]

To the best of my knowledge, only if you build the query in VBA code. Often this is a sign of a non-normalized database. What do the different tables contain?