running a query on a list of tables

I can run :

I can run :

SELECT * FROM tablelist;

which returns a list of tables

names

----------------

mortgage

creditcard

auto

........continued

I want to run :

SELECT * FROM (SELECT * FROM tablelist);

all tables have the same columns and types.

any idea how to make this work? tablelist contains a large number of tables that will change over time and I do not want to manually write a bunch of unions.

any suggestions?

Thank you