Received: from thor.tht.net ([209.47.145.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0M6lR086024 for ; Mon, 22 Jan 2001 01:47:32 -0500 (EST) (envelope-from srichter@cbu.edu) Received: from cbu.edu (mercury-1.cbu.edu [198.78.130.6]) by thor.tht.net (8.9.3/8.9.3) with ESMTP id BAA02546 for ; Mon, 22 Jan 2001 01:23:25 -0500 (EST) (envelope-from srichter@cbu.edu) Received: from lorentz.cbu.edu (lorentz.cbu.edu [192.168.160.7]) by cbu.edu (8.9.3+Sun/8.9.3) with ESMTP id AAA07324 for ; Mon, 22 Jan 2001 00:17:47 -0600 (CST) Message-Id: <4.3.1.0.20010122001803.00a99dd0@198.78.130.6> X-Sender: srichter@198.78.130.6 X-Mailer: QUALCOMM Windows Eudora Version 4.3.1 Date: Mon, 22 Jan 2001 00:20:14 -0600 To: From: Stephan Richter Subject: Joining several tables Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Archive-Number: 200101/277 X-Sequence-Number: 946 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