[thelist] dynamic table sql question

Ed McCarroll Ed at ComSimplicity.com
Mon Apr 25 13:00:00 CDT 2005


> 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


More information about the thelist mailing list