Received: from redbox.venux.net (redbox.venux.net [216.47.238.10]) by hub.org (8.9.2/8.9.1) with ESMTP id UAA18694 for ; Wed, 24 Feb 1999 20:25:40 -0500 (EST) (envelope-from matthew@venux.net) Received: from thunder (net177138.hcv.com [209.153.177.138]) by redbox.venux.net (Postfix) with SMTP for id 48E4F2E209; Wed, 24 Feb 1999 20:25:16 -0500 (EST) Message-Id: <4.1.19990224201140.009a9820@mail.venux.net> X-Sender: mhagerty@mail.venux.net X-Mailer: QUALCOMM Windows Eudora Pro Version 4.1 Date: Wed, 24 Feb 1999 20:25:12 -0500 To: pgsql-sql@postgresql.org From: Matthew Hagerty Subject: OUTER JOINS in 6.4.2?? Work around?? Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Greetings, I know this is probably asked a thousand times, but I cannot find a reference anywhere on the web site. If there is one, please point me there... Is it possible to do LEFT and RIGHT OUTER JOINS? i.e. SELECT * FROM foo LEFT OUTER JOIN bar ON foo.id=bar.id; All I could find on the web site was that PostgreSQL supports a subset of SQL92 and SQL3. Is there someplace that tells what that subset is? Maybe I don't need the join if there is some other way... I'm trying to work out a query to give me one row from the many side of a 1-to-many relationship for each row in the one side; basically making a 1-to-1 by ignoring extra rows in the many table. For instance, a table of customers (the one table) have phone numbers (the many table). I want to display a list of customers with a phone number, but only one number regardless of how many phone numbers there are. Any insight would be greatly appreciated. Thanks, Matthew