Join with blank records.

From: Matthew Hagerty <matthew(at)venux(dot)net>
To: pgsql-sql(at)postgreSQL(dot)org
Subject: Join with blank records.
Date: 1999-07-28 18:05:34
Message-ID: 4.1.19990728134746.03f6c4d0@mail.venux.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Greetings,

I have two tables, one is customers and one is their phones. Something
simple like this:

customer
cust_id int4
cust_name varchar(30)

phone
cust_id int4
number varchar(15)

select c.*, p.number from customer and c, phone as p
where c.cust_name='smith'
and p.cust_id = c.cust_id;

The problem I am having with this is that only records in the customer
table that have matching records in the phone number table are showing up.
What I would really like is for all records that match the first criteria
to show up regardless if they have matching phone number records.

Any insight would be greatly appreciated.

Thank you,
Matthew Hagerty

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Peter Eisentraut 1999-07-28 20:14:32 Re: [SQL] Join with blank records.
Previous Message Tom Lane 1999-07-28 17:47:23 Re: [SQL] WHERE parent IN (0,-1)