Received: from mail01.phoenixdsl.com (mail.phoenixdsl.com [216.178.151.24]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0MI0V054248 for ; Mon, 22 Jan 2001 13:00:31 -0500 (EST) (envelope-from mdavis@sevainc.com) Received: (qmail 34416 invoked by uid 89); 22 Jan 2001 18:00:30 -0000 Received: from unknown (HELO SALLY) (64.32.157.45) by 0 with SMTP; 22 Jan 2001 18:00:30 -0000 Received: by localhost with Microsoft MAPI; Mon, 22 Jan 2001 11:00:29 -0700 Message-ID: <01C08462.886C1520.mdavis@sevainc.com> From: Michael Davis Reply-To: "mdavis@sevainc.com" To: "'Stephan Richter'" , "pgsql-sql@postgresql.org" Subject: RE: Joining several tables Date: Mon, 22 Jan 2001 11:00:23 -0700 Organization: Seva Inc. X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Archive-Number: 200101/278 X-Sequence-Number: 947 1) Select t1.* from table_1 t1, table2 t2 where t1.column = t2.column; 2) Select t1.* from table_1 t1 join table2 t2 on t1.column = t2.column; -----Original Message----- From: Stephan Richter [SMTP:srichter@cbu.edu] Sent: Sunday, January 21, 2001 11:20 PM To: pgsql-sql@postgresql.org Subject: Joining several tables Hello, I have the following situation: I have an Address, PhoneNumber and Contact table all having a contactid in common, but sometimes the phone number does not exist. I want to join these three tables. How do I do that? I could not find the syntax for multiple tables... Regards, Stephan -- Stephan Richter CBU - Physics and Chemistry Student Web2k - Web Design/Development & Technical Project Management