> select * from (select distinct job_name from jobs) > where phonenumber IN ( <<numbers here>> ) Off the top of my head (no way to test here): SELECT * FROM WhateverTable W INNER JOIN jobs J ON J.job_name = W.job_name WHERE phonenumber IN ( <<numbers here>> ) -------------------------------------------------------------------- Ed McCarroll (310) 838-4330 Ed at ComSimplicity.com http://www.ComSimplicity.com