the opposite of a join?

[<jd.pillion@xxxxxxxxx>]

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