Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!apple!voder!blia!blipyramid!mike
From: mike@blipyramid.BLI.COM (Mike Ubell)
Newsgroups: comp.databases
Subject: Re: Dumb Question (Outer Join)
Message-ID: <106@blipyramid.BLI.COM>
Date: 9 Jun 89 20:30:41 GMT
References: <423@cimshop.UUCP> <1118@stech.UUCP>
Reply-To: mike@blipyramid.UUCP (Mike Ubell)
Organization: Britton Lee
Lines: 22

In article <1118@stech.UUCP> jlh@stech.UUCP (Jan Harrington) writes:
>in article <423@cimshop.UUCP>, davidm@cimshop.UUCP (David Masterson) says:
>> 
>> I know I'm going to kick myself when I find the answer to this, but...
>> 
>> What is the method for doing an outer join in SQL?  For instance, given:
> Add (*) after the join condition, as in:
>
>select people.name, orders.invoice#, orders.item
>from people, orders
>where people.id = orders.id (*);
>
>Jan Harrington
>Scholastech Telecommunications
>husc6!stech!jlh or allegra!stech!jlh

This is only true in Oracle (I think).  The ANSI sql 1986 standard does
not define an outer join.  The proposed sql2 standard has a very differnet
syntax.  Something like:
	select...
	form A left join B on <predicate>
	where