Received: from alpha.science.unitn.it (alpha.science.unitn.it [193.205.194.23]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA33840 for ; Thu, 10 Jun 1999 18:39:55 -0400 (EDT) (envelope-from ant9000@seldati.it) Received: from chomp (ant9000@beta.science.unitn.it [193.205.194.114]) by alpha.science.unitn.it (8.8.8/8.8.8) with SMTP id AAA09870; Fri, 11 Jun 1999 00:41:19 +0200 (MET DST) From: Ant9000 To: pgsql-sql@postgreSQL.org Subject: Re: [SQL] OUTER JOINs in PostgreSQL Date: Sat, 5 Jun 1999 15:56:31 +0200 X-Mailer: KMail [version 1.0.17] Content-Type: text/plain References: <199906022108.PAA13896@earlj.nesusa.com> Cc: Jason Earl MIME-Version: 1.0 Message-Id: <99060516013600.00767@chomp> Content-Transfer-Encoding: 8bit X-KMail-Mark: Reply-To: On Wed, 02 Jun 1999, you wrote: >I think that you are looking for something like: > >SELECT m.id, m.name, d.lastvisit, d.info > FROM master m, detail d > WHERE m.id = d.id; > >Jason > No, that way I get an inner join: in my example the result would be id | name | lastvisit | info ----------------------------- 1 | Alpha | Wed Jun 02 19:43:08 1999 CEST | blah blah 1 | Alpha | Wed Jun 02 19:45:08 1999 CEST | some more blah's and I'm instead looking for this output: id | name | lastvisit | info ----------------------------- 1 | Alpha | Wed Jun 02 19:43:08 1999 CEST | blah blah 1 | Alpha | Wed Jun 02 19:45:08 1999 CEST | some more blah's 2 | Beta | | 3 | Gamma | |