Date:         Thu, 7 Mar 2002 15:35:33 -0500
Reply-To:     Dianne Rhodes <RHODESD1@WESTAT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Dianne Rhodes <RHODESD1@WESTAT.COM>
Subject:      Re: SQL logic
Content-Type: text/plain; charset="iso-8859-1"

 >Peter Baade asked:
 >> Is there recommended manual for SQL? We use SQL for both
 >SAS and ORACLE
 >> (I understand there are some differences), so recommendations
 >> for both types would be much appreciated.
 >
 >      Oracle's implementation is PL-SQL, unique to Oracle.
 >      SAS's implementation is also unique.
 >
Dan Keating replied:
 >      But a great book with clear examples of how to make SQL
 >bend to your
 >will is Joe Celko's SQL for Smarties: Advanced SQL Programming.
 >


I second that.  If you are just starting, I'd look at The Practical SQL
Handbook by Sandy Emerson, et al.
It gives you complete examples and notes the differences between the
standard and the
implementation by Oracle, Sybase, Informix, etc. etc.  It also has a very
good explanation of 4th normal form.
It doesn't include SAS (neither does Celko), but is general enough that it
should be of help.

Most excellent paper, BTW SQL for data step die hards.  But the Author is
Christianna Williams,
not Christina.  <plug on> I hope we will have her at NESUG 15 in Buffalo
<plug off>

Dianne Louise Rhodes
Sr. Systems Analyst
Westat