Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP Path: utzoo!utgpu!water!watmath!clyde!cbosgd!cwruecmp!hal!ncoast!allbery From: allbery@ncoast.UUCP Newsgroups: comp.databases Subject: Re: SQL reference Message-ID: <4188@ncoast.UUCP> Date: Sun, 16-Aug-87 15:19:34 EDT Article-I.D.: ncoast.4188 Posted: Sun Aug 16 15:19:34 1987 Date-Received: Tue, 18-Aug-87 00:49:43 EDT References: <463@ems.MN.ORG> Reply-To: allbery@ncoast.UUCP (Brandon Allbery) Followup-To: comp.databases Organization: Cleveland Public Access UN*X, Cleveland, Oh Lines: 27 As quoted from <463@ems.MN.ORG> by barker@ems.MN.ORG (Bob W. Barker): +--------------- | Can anyone recommend a reference for learning advanced SQL techniques? | I am using Unify 3.2 and find the SQL section of the Unify reference manual | to be a good basic source of information but not as good with advanced | applications. If there is a book that might help me out (especially one | that I might find at the local book store) I'd appreciate hearing about it. | Anything with examples of SQLs would be helpful. Thanks! +--------------- You're going to have problems with off-the-shelf SQL references: UNIFY SQL (pre 4.0, at least) is not ANSI compatible. Much of the SELECT statement is compatible, ditto UPDATE, but INSERT and DELETE are quite different. There are also differences in the specification of tuples (UNIFY uses <>, ANSI uses ()) and missing functions (SELECT ... WHERE FOO = ANY (SELECT ...) doesn't exist in UNIFY SQL). This is a major pain when it comes to advanced SQL. (Note that "xyzzy = ANY (SELECT foo ...)" can be done in UNIFY SQL by coding it as "SELECT COUNT(*) ... WHERE xyzzy = foo ...; ^= 0". And beware of the subquery handling: ANSI encloses subqueries in parentheses, UNIFY looks for the keyword SELECT and ends a subquery with a semicolon in place of the slash.) -- Brandon S. Allbery, moderator of comp.sources.misc and comp.binaries.ibm.pc {{harvard,mit-eddie}!necntc,well!hoptoad,sun!mandrill!hal}!ncoast!allbery ARPA: necntc!ncoast!allbery@harvard.harvard.edu Fido: 157/502 MCI: BALLBERY <> ** Site "cwruecmp" is changing its name to "mandrill". Please re-address ** *** all mail to ncoast to pass through "mandrill" instead of "cwruecmp". ***