Received: from dfw-ix8.ix.netcom.com (dfw-ix8.ix.netcom.com [206.214.98.8]) by hub.org (8.9.3/8.9.3) with ESMTP id VAA47721 for ; Tue, 17 Aug 1999 21:45:45 -0400 (EDT) (envelope-from hamid@emarq.com) Received: (from smap@localhost) by dfw-ix8.ix.netcom.com (8.8.4/8.8.4) id UAA11156 for ; Tue, 17 Aug 1999 20:45:14 -0500 (CDT) Received: from unknown(207.230.254.117) by dfw-ix8.ix.netcom.com via smap (V1.3) id rma011134; Tue Aug 17 20:44:42 1999 From: "Hamid Khoshnevis" To: Subject: Using intersect in subquery Date: Tue, 17 Aug 1999 18:55:23 -0700 Message-ID: <001f01bee91c$bc180740$810a0a0a@local.dom> 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 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Importance: Normal I have tried to use intersect in subquery causing the following error. Please help! ERROR: parser: parse error at or near "intersect" select * from Table1 where KeyField1 in (select KeyField2 from Table2 where somecondition intersect select KeyField3 from Table3 where somecondition); (I believe) I am running PG 6.4. The INTERSECT by itself works, but not in a subquery. Thanks! hamid