Path: utzoo!attcan!utgpu!utstat!jarvis.csri.toronto.edu!mailrus!husc6!stech!jlh
From: jlh@stech.UUCP (Jan Harrington)
Newsgroups: comp.databases
Subject: Re: Dumb Question (Outer Join)
Message-ID: <1118@stech.UUCP>
Date: 9 Jun 89 11:07:02 GMT
References: <423@cimshop.UUCP>
Organization: Scholastech, Inc., Waltham, Mass.
Lines: 20

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

*************************************************************************
	Miscellaneous profundidity:
		"No matter where you go, there you are..."
			Buckaroo Banzai
*************************************************************************