Received: from mail.global.co.za (mail.global.co.za [196.3.164.40]) by hub.org (8.9.2/8.9.1) with ESMTP id PAA34107 for ; Wed, 31 Mar 1999 15:54:47 -0500 (EST) (envelope-from Frans@Playful.com) Received: from carolina (syn06.anx6.rivA.gia.net.za [209.88.77.71]) by mail.global.co.za (8.9.2/8.9.1) with SMTP id WAA21053 for ; Wed, 31 Mar 1999 22:54:30 +0200 (GMT) From: "Frans de Wet" To: Subject: Retrieving the record not matched with a join. Date: Wed, 31 Mar 1999 22:53:49 +0200 Message-ID: <000101be7bb8$93709360$0101a8c0@carolina> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 In-Reply-To: <19990331171611.B12083@kfs.org> Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Hi, I have two tables, A and B. A contains records which includes an ID or one of the records in table B. A would typically contain the fields: IDA IDB DATA1 DATA2 and B: IDB DATA3 DATA4 I have several records in both but a few of the records in A has a IDB field which does not point to a valid record in B (the record has been deleted). I know how to get all the records in A that have existing records in B. SELECT * FROM A, B WHERE A.BID = B.BID. Now my question ... How do I get the records in A that DO NOT have existing records in B ??? Perplexed look and deep frown ;-) Thanks in Advance Frans