the opposite of a join?

From: Date: Wed, 03 Oct 2007 10:21:06 +0000
Subject: the opposite of a join?
Groups: php.db php.general 
Request: Send a blank email to php-db+get-44101@lists.php.net to get a copy of this message
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 opposite of a join? Thanks J

« previous php.db (#44101) next »