Selecting Across Multiple Tables

[raouleduke]

I am trying to compile a list across multiple tables, how do I compile the list of tables and select from them.
Thanks in advance.

[tekky]

searching on google would help.....
searching here would help...

therwise you might try

SELECT table1.column1, table1.column2, table2.column1, table2.column2 FROM table1, table2 WHERE table1.column2 = table2.column1

[raouleduke]

I have one table where I keep all the table names, I want to select from that table and compile a list of all the other tables. And then use my select statement to find out if are any records in all the tables that have my criteria.
Do I need to use a for each statement, I will start searching also.
Thanks,