Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!csd4.milw.wisc.edu!leah!rpi!batcomputer!cornell!rochester!rit!tropix!moscom!ur-valhalla!uhura.cc.rochester.edu!sunybcs!rutgers!tut.cis.ohio-state.edu!ucbvax!agate!hughes@math.Berkeley.EDU
From: hughes@math.Berkeley.EDU (Eric Hughes)
Newsgroups: comp.databases
Subject: Re: Dumb Question (Outer Join)
Message-ID: <25581@agate.BERKELEY.EDU>
Date: 22 Jul 89 05:55:16 GMT
References: <423@cimshop.UUCP>
Sender: usenet@agate.BERKELEY.EDU
Reply-To: hughes@math.Berkeley.EDU (Eric Hughes)
Organization: UCB Mathematics Department
Lines: 22
In-reply-to: davidm@cimshop.UUCP (David Masterson)

In article <423@cimshop.UUCP>, davidm@cimshop (David Masterson) writes:
>	A 1 2		B 1 2
>	  a b		  a a
>	  c d		  c c
>
>The outer join of "A.1 = B.1" should be:
>
>		a b a a
>		a b _ _
>		c d c c
>		c d _ _

If I remember this correctly, what you have specified is a left handed
outer join.  For a full outer join, you also need the lines

		_ _ a a
		_ _ c c

Admittedly, a one-sided outer join is more useful.

Eric Hughes
hughes@math.berkeley.edu   ucbvax!math!hughes