Dynamic Select Statements

Hi there,

Is there a way to have dynamic select statements such that

the Table name can be dynamically given and field names for selection criterion should be dynamically given in the select statment.

To be more precise, I have set of tables for which I need to fetch data from the database using a single select statment.

If any of you have a solution .please revert ASAP.

Many thanks

ugesh