Dear All, Need to find ids that are NOT in other two tables. With the help of PHP scripting and three queries I am able to do the task. Can this be done with one mysql query? Below are current quires: SELECT DISTINCT company_id FROM company_db SELECT company_id FROM person WHERE company_id=\"$company_id\" SELECT company_id FROM customer WHERE company_id=\"$company_id\" Thanks in advance for any help.
--------------------------------- How low will we go? Check out Yahoo! Messengers low PC-to-Phone call rates.