Received: from wallace.ece.rice.edu (wallace.ece.rice.edu [128.42.12.154])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0HHES037916;
	Wed, 17 Jan 2001 12:14:30 -0500 (EST)
	(envelope-from reedstrm@rice.edu)
Received: by rice.edu via sendmail from stdin
	id <m14IwAE-000LGvC@wallace.ece.rice.edu> (Debian Smail3.2.0.102)
	for pgsql-sql@postgresql.org; Wed, 17 Jan 2001 11:14:26 -0600 (CST)
Date: Wed, 17 Jan 2001 11:14:26 -0600
From: "Ross J. Reedstrom" <reedstrm@rice.edu>
To: pgsql-sql@postgresql.org, pgsql-interfaces@postgresql.org
Subject: Re: outer join in PostgreSql
Message-ID: <20010117111426.A21852@rice.edu>
Mail-Followup-To: pgsql-sql@postgresql.org, pgsql-interfaces@postgresql.org
References: <Pine.GSO.4.10.10101151201390.22937-100000@athena.ics.forth.gr>
	<012701c07f40$c7c0a6e0$0672148f@cadm.pjud>
	<3A63D83D.93FE66A4@alumni.caltech.edu> <3A647A62.BB0B0DA@tm.ee>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
User-Agent: Mutt/1.0i
In-Reply-To: <3A647A62.BB0B0DA@tm.ee>;
	from hannu@tm.ee on Tue, Jan 16, 2001 at 06:44:18PM +0200
X-Archive-Number: 200101/172
X-Sequence-Number: 788

On Tue, Jan 16, 2001 at 06:44:18PM +0200, Hannu Krosing wrote:
> 
> To get a feel you could use MS Access visual query builder and then view
> the source.
> I have not checked it lately, but it very likely produces SQL92
> compliant outer joins.
> 

I fired up MS-Access 97SR1, just to see, and here's one result:

SELECT Institution.InstitutionName, InstituteAssignment.PersonID FROM
Institution LEFT JOIN InstituteAssignment ON Institution.InstID =
InstituteAssignment.InstID;

I'm surprised: looks pretty standard, to me.

Ross
-- 
Open source code is like a natural resource, it's the result of providing
food and sunshine to programmers, and then staying out of their way.
[...] [It] is not going away because it has utility for both the developers 
and users independent of economic motivations.  Jim Flynn, Sunnyvale, Calif.