Is there anyway to use a tablename in subquery?

Is there anyway to use a tablename in subquery like this:

SELECT * FROM ( SELECT tablebame FROM TABLE);

Thanks.

Jia Lu Received on Tue May 26 2009 - 23:50:54 CDT