Re: [GENERAL] off Topic: Looking for a good sql query

2004-11-25 Thread felix 
On Fri, Nov 26, 2004 at 01:19:59PM +1100, Jamie Deppeler wrote:

> This post is a bit off topic im looking a good sql book can someone give 
> me a recommendation?

I am a middling SQL guy; I have used functions, triggers, outer joins,
etc, but not often.  But I've been doing that for years :-) my
personal favorite is SQL Visual Quickstart Guide, Chris Fehily,
Peachpit Press, 2002, ISBN 0-201-11803-0.  It has lots of examples, it
remains steadily boring and consistent throughout, it goes from really
basic stuff to pretty fancy stuff, and most precious of all, it covers
five databases and tells you exactly how every single example differs
from db to db --

MS Access
MS SQL Server
MySQL
Oracle
PostgreSQL

If I only had one SQL book, this would be it.

-- 
... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._.
 Felix Finch: scarecrow repairman & rocket surgeon / [EMAIL PROTECTED]
  GPG = E987 4493 C860 246C 3B1E  6477 7838 76E9 182E 8151 ITAR license #4933
I've found a solution to Fermat's Last Theorem but I see I've run out of room o

---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] off Topic: Looking for a good sql query

2004-11-25 Thread Jim Seymour 
Jamie Deppeler <[EMAIL PROTECTED]> wrote:
> 
> Hi,
> 
> This post is a bit off topic im looking a good sql book can someone give 
> me a recommendation?

I was pleased with...

The Practical SQL Handbook
Third Edition
Judith S. Bowman, Sandra L. Emerson, & Marcy Darnovsky
Addison-Wesley Developers Press
A Division of Addison Wesley Longman, Inc.
ISBN: 0-201-44787-8 (softcover, incl. CD-ROM)

There's a 4th Edition out now.  Here's Bookpool's listing:

http://www.bookpool.com/.x/mrbet2p3z1/ss?qs=The+Practical+SQL+Handbook&x=0&y=0

I'm toying with the idea of selling, donating or trading-in my 3rd
edition and picking-up the 4th.

Jim

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html

[GENERAL] off Topic: Looking for a good sql query

2004-11-25 Thread Jamie Deppeler 
Hi,
This post is a bit off topic im looking a good sql book can someone give 
me a recommendation?

---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]