From: Ross J. Reedstrom <reedstrm@rice.edu>
To: pgsql-sql@postgresql.org
To: pgsql-interfaces@postgresql.org
Subject: Re: outer join in PostgreSql
Date: Wed, 17 Jan 2001 11:14:26 -0600
Message-ID: <20010117111426.A21852@rice.edu> (raw)
In-Reply-To: <3A647A62.BB0B0DA@tm.ee>
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>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: reedstrm@rice.edu, pgsql-sql@postgresql.org
Subject: Re: outer join in PostgreSql
In-Reply-To: <20010117111426.A21852@rice.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox