Path: utzoo!utgpu!water!watmath!clyde!burl!codas!ufcsv!ukma!psuvm.bitnet!uh2
From: UH2@PSUVM.BITNET (Lee Sailer)
Newsgroups: comp.databases
Subject: Re: R:base for DOS
Message-ID: <30375UH2@PSUVM>
Date: 21 Jan 88 14:37:47 GMT
References: <417@stech.UUCP>
Organization: Penn Sate Erie--School of Business
Lines: 21

In article <417@stech.UUCP>, sysop@stech.UUCP (Jan Harrington) says:
>
>However --- (and this is a big however) --- a view can be created which
>_does_ query multiple tables.  I'm very surprised that the CREATE VIEW
>statement allows a SQL-like SELECT (e.g., multiple tables) but the stand-
>alone SELECT doesn't.  Anybody from Microrim out there?  How 'cum, guys?
>If it can be done with a view, why not with a SELECT?
     
1.  I'm surpised too.  The whole point of the new RBASE was to add SQL.
If the new SELECT cannot access multiple tables then I will lose all
respect for the marketing people at MicroRim 8-)
     
2.  Even in RBASE SV, the VIEW command could do a natural join across
multiple tables.  Does the new rBase add anything to that?
     
3.  I considered getting the new rBase, but finally decided to invoke the
"never buy anything less than a year old or you'll be the one to find
all the bugs" proverb.  (I still find the bugs in SV1.0 8-)
     
lee