Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!rochester!pt.cs.cmu.edu!cadre!pitt!amanue!oglvee!norm
From: norm@oglvee.UUCP (Norman Joseph)
Newsgroups: comp.databases
Subject: Re: Dumb Question (Outer Join)
Message-ID: <482@oglvee.UUCP>
Date: 13 Jun 89 13:02:36 GMT
References: <106@blipyramid.BLI.COM>
Organization: Oglevee Computer Systems, Connellsville, Pa
Lines: 22

From article <106@blipyramid.BLI.COM>, by mike@blipyramid.BLI.COM (Mike Ubell):
# In article <1118@stech.UUCP> jlh@stech.UUCP (Jan Harrington) writes:
#>in article <423@cimshop.UUCP>, davidm@cimshop.UUCP (David Masterson) says:
#>> 
#>> 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 (*);
# 
# This is only true in Oracle (I think).

The last time I used Oracle, version 4.<something> on an HP 925 last fall,
the magic join symbol was (+), not (*), but still used in the way described
by Jan above.  I cannot say that this is standard syntax across different
SQL implementations.  In fact, (cynic that I am :-) I doubt it.
-- 
Norm Joseph - Oglevee Computer System, Inc.
  UUCP: ...!{pitt,cgh}!amanue!oglvee!norm
    /* you are not expected to understand this */