Path: utzoo!mnetor!uunet!husc6!amcad!stech!sysop
From: sysop@stech.UUCP (Jan Harrington)
Newsgroups: comp.databases
Subject: R:base for DOS
Message-ID: <417@stech.UUCP>
Date: 20 Jan 88 12:27:53 GMT
Organization: Scholastech, Inc., Waltham, Mass.
Lines: 27

Well, R:base for DOS appeared via UPS person yesterday.  The first thing I
did was grab the user's manual out of the box and look at what they'd done
to the SELECT command.  Why?  One of my greatest problems with the package
(and I really do like it) was that SELECT could only query a single table.

I had hoped, with the advertising of SQL, that SELECT would be a SQL SELECT
and that it would allow multiple table queries.  Unfortunately, that is not
the case.  Thought Microrim has added SELECT DISTINCT and grouping queries,
each still works off a single table or view.  I'm very disappointed.

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?


Jan Harrington, sysop
Scholastech Telecommunications
ihnp4!husc6!amcad!stech!sysop or allegra!stech!sysop

********************************************************************************
	Miscellaneous profundity:

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