Received: from redbox.venux.net (redbox.venux.net [216.47.238.10]) by hub.org (8.9.3/8.9.3) with ESMTP id OAA20122 for ; Wed, 28 Jul 1999 14:05:47 -0400 (EDT) (envelope-from matthew@venux.net) Received: from thunder (net177138.hcv.com [209.153.177.138]) by redbox.venux.net (Postfix) with SMTP for id 3466E2E20B; Wed, 28 Jul 1999 14:06:29 -0400 (EDT) Message-Id: <4.1.19990728134746.03f6c4d0@mail.venux.net> X-Sender: mhagerty@mail.venux.net X-Mailer: QUALCOMM Windows Eudora Pro Version 4.1 Date: Wed, 28 Jul 1999 14:05:34 -0400 To: pgsql-sql@postgreSQL.org From: Matthew Hagerty Subject: Join with blank records. Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" 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