Received: from nss4.cc.Lehigh.EDU (root@nss4.CC.Lehigh.EDU [128.180.1.13]) by hub.org (8.8.8/8.7.5) with ESMTP id NAA14730 for ; Mon, 3 Aug 1998 13:43:45 -0400 (EDT) Received: from dummy.res.lehigh.edu (phil.CC.lehigh.EDU [128.180.3.62]) by nss4.cc.Lehigh.EDU (8.8.8/8.8.5) with SMTP id NAA31972; Mon, 3 Aug 1998 13:43:26 -0400 Message-ID: <009401bdbf06$37fd5460$3e03b480@dummy.res.lehigh.edu> From: "Phil R Lawrence" To: , Cc: "UserGuideDog" Subject: Re: [SQL] locked my keys in the car Date: Mon, 3 Aug 1998 13:43:24 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 >So my next question is: >Is there a way, using SQL, to do the math on this, i.e., to rm the >patients who appear twice - once in the first query, once in the second? >(God forbid we re-admit the same patient at some future date!) Try MINUS. SQL1 MINUS SQL2 yields SQL1's results minus any also found in SQL2.