Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP
Path: utzoo!mnetor!uunet!ukma!psuvm.bitnet!uh2
From: UH2@PSUVM.BITNET (Lee Sailer)
Newsgroups: comp.databases
Subject: Re: Outer join in SQL
Message-ID: <25882UH2@PSUVM>
Date: Mon, 23-Nov-87 14:16:11 EST
Article-I.D.: PSUVM.25882UH2
Posted: Mon Nov 23 14:16:11 1987
Date-Received: Thu, 26-Nov-87 23:15:25 EST
References: <1804@cognos.UUCP>
Organization: The Pennsylvania State University - Computation Center
Lines: 18

RBASE manages to disquise its JOINs in several interesting ways.
     
1.  The VIEW is a virtual natural join of up to 5 relations.
     
2.  The JOIN is a Theta-Join of two tables.
     
3.  The INTERSECTION command---ah, yes---is (1) an Intersection if
both relations (tables) have identical columns, or (2) a natural join
otherwise.
     
4.  The UNION command is a relational Union if the tables have identical
columns, or an Outer Join otherwise.
     
RBASE seems to have lots of the important parts, but Oh My do they ever
organize things in bizarre ways.
     
lee