[PHP] the opposite of a join?

I have a company table and a contacts table. In the contacts table, there is a field called companyID which is a link to a row in the company table. What is the easiest way to query the company table for all the company rows whose ID is NOT linked to in the contact table? Basically, the

Re: [PHP] the opposite of a join?

2007. 10. 3, szerda keltezéssel 05.21-kor [EMAIL PROTECTED] ezt írta: I have a company table and a contacts table. In the contacts table, there is a field called companyID which is a link to a row in the company table. What is the easiest way to query the company table for all the

Re: [PHP] the opposite of a join?

WHERE DepartmentID IS NULL. -TG - Original Message - From: [EMAIL PROTECTED] To: php-general@lists.php.net, [EMAIL PROTECTED] Date: Wed, 3 Oct 2007 05:21:06 -0500 Subject: [PHP] the opposite of a join? I have a company table and a contacts table. In the contacts table

Re: [PHP] the opposite of a join?

- Original Message - From: Zoltán Németh [EMAIL PROTECTED] it's not very efficient, but I don't have any better idea. someone else? Indeed, that sort of query is one of the worst and there is little you can do to improve it save making sure you have an index on the field of the

Re: [PHP] the opposite of a join?

On 10/3/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I have a company table and a contacts table. In the contacts table, there is a field called companyID which is a link to a row in the company table. What is the easiest way to query the company table for all the company rows whose

Re: [PHP] the opposite of a join?

[EMAIL PROTECTED] wrote: I have a company table and a contacts table. In the contacts table, there is a field called companyID which is a link to a row in the company table. What is the easiest way to query the company table for all the company rows whose ID is NOT linked to in the contact