barker@ems.MN.ORG (Bob W. Barker) (08/11/87)
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!
-Bob Barker
--------------------------------------------------------------------------------
Bob Barker UUCP: {ihnp4|rutgers|amdahl}!{dayton|meccts}!ems!barker
EMS/McGraw-Hill ATT: (612) 829-8200
9855 West 78th Street FAX: (612) 829-1839
Eden Prairie, MN 55344allbery@ncoast.UUCP (08/16/87)
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 <<ncoast Public Access UNIX: +1 216 781 6201 24hrs. 300/1200/2400 baud>> ** Site "cwruecmp" is changing its name to "mandrill". Please re-address ** *** all mail to ncoast to pass through "mandrill" instead of "cwruecmp". ***