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 ID is NOT linked to in the contact table? Basically, the opposite of > a > join?
SELECT company.* FROM company LEFT JOIN contacts ON (company.companyID = contacts.companyID) WHERE contacts.companyID IS NULL (Assuming your DB can handle a left join) -James Thanks > > > > J > > > >
