Sorry, I wasn't thinking clearly. The correct answer is: Select * FROM A WHERE A.Company not in ( Select B.Company FROM A, B WHERE A.Company = B.Company ) Rob Smith LexJet rob.smith at lexjet.com http://www.lexjet.com (800)453-9538 (941)330-1210 Int'l (941)330-1220 Fax 1680 Fruitville Road, 3rd Floor Sarasota, FL 34236 Proud Sponsors of the Professional Digital Imaging Association (www.pdia.org)