Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!cornell!uw-beaver!sumax!amc-gw!sigma!sea375!dave
From: dave@sea375.UUCP (David A. Wilson)
Newsgroups: comp.databases
Subject: Re: outer join question
Message-ID: <257@sea375.UUCP>
Date: 14 Jan 90 22:56:01 GMT
References: <1751@cod.NOSC.MIL>
Distribution: usa
Organization: At Home in Seattle, WA
Lines: 19

From article <1751@cod.NOSC.MIL>, by dberg@cod.NOSC.MIL (David I. Berg):
> 
> Use the SQL construct: select x,y,... from a OUTER b where.....,
> like so:
> 
> "select socsec, name, amount_owed from table1 t1, OUTER table2 t2
> where t1.socsec = t2.socsec" 
> 
Is the 'outer' specifier in any ANSI SQL standard? I sure haven't seen it
in most RDBMS systems I have encountered. I believe a few exist that do
implement outer joins but the last SQL specification I saw did not include
it. If anyone working on the ANSI SQL standard reads this, I hope outer join
will become part of the ANSI SQL soon. All other work arounds for solving
outer join problems are usually slow and ugly(definitely not for anyone with
a weak stomach.).
-- 
	David A. Wilson
	dave@sea375.uucp
	...uw-beaver!uw-entropy!quick!sigma!sea375!dave