i'm trying to write a simple query to check each and every table for a certain group of phone numbers from another table which lists all the jobs and its properties. this is what i want to do... select * from (select distinct job_name from jobs) where phonenumber IN ( <<numbers here>> ) basically, i want to cycle through each job name from the Jobs table, and within the same database, there is a table with that Job name. I.e. Jobs holds: Job1, Job2 and I have the following tables: Jobs Job1 Job2 in my main listing under the DB. I know this syntax fails.. but is there a way to do such a thing? I really don't want to go through and do this manually for 300 different job tables to see if those phone numbers are in it.