Path: utzoo!attcan!uunet!cimshop!davidm
From: davidm@cimshop.UUCP (David Masterson)
Newsgroups: comp.databases
Subject: Dumb Question (Outer Join)
Message-ID: <423@cimshop.UUCP>
Date: 9 Jun 89 01:22:49 GMT
Organization: Consilium Mt. View CA
Lines: 21

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:

	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 _ _

but how do you express it in standard SQL????

aTdHvAaNnKcSe

David Masterson					(preferred address)
uunet!cimshop!davidm		or		DMasterson@cup.portal.com