Joining several tables

From: Stephan Richter <srichter(at)cbu(dot)edu>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Joining several tables
Date: 2001-01-22 06:20:14
Message-ID: 4.3.1.0.20010122001803.00a99dd0@198.78.130.6
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message kisix 2001-01-22 16:47:58 select returns no line
Previous Message Tom Lane 2001-01-22 05:34:37 Re: Question about 'copy' and datetime