Received: from www.base2inc.com (www.base2inc.com [204.117.190.140]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1CIKWx40284 for ; Mon, 12 Feb 2001 13:20:32 -0500 (EST) (envelope-from fmorton@base2inc.com) Received: from edison (edison.base2inc.com [206.229.85.132]) by www.base2inc.com (8.9.3/8.9.3) with SMTP id NAA07951 for ; Mon, 12 Feb 2001 13:19:02 -0500 Message-ID: <012501c09520$74e7bc10$8455e5ce@edison> From: "Frank Morton" To: Subject: combining Date: Mon, 12 Feb 2001 13:20:19 -0500 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 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Archive-Number: 200102/225 X-Sequence-Number: 1416 I'll really appreciate help on this if anyone will do so. I'm used to single-table stuff, but not sure the best way to do things with multiple tables, but here goes: Given two tables with a common "id" field, first table columns: id lastname Second table columns: id type content These two queries get me what I want from each table: select unique id from table1 where lastname='morton'; select unique id from table2 where ((type = "pie") and (content = 'apple)); What is the best way to combine these into one query? Thanks. Frank