Help - I need a book on SQL

6 Jan 2006 4:29 PM

JD

Im trying to write a complicated SQL in analyser using several tables and sub
selects to do some inserts.

I have to do this very often and I only have a limited knowledge of SQL.

Can you recommend a book I can go out and buy that will teach me how to
write involved SQLs for a beginner please.

(The name and author would be great).

Thanks, confused and frustrated!

6 Jan 2006 4:58 PM

SQL

If there is one book that I would get this would be it

The Guru's Guide to Transact-SQL

by Ken Henderson

http://www.amazon.com/exec/obidos/tg/detail/-/0201615762/ref=ase_sql08-20/102-4703055-5891314?v=glance&s=books

and BOL of course

http://sqlservercode.blogspot.com/

6 Jan 2006 6:07 PM

Smithers

Very good book for writing queries, specifically (as opposed to db design):

"SQL Queries For Mere Mortals" by Hernandez and Viescas

http://www.amazon.com/gp/product/0201433362/qid=1136570687/sr=2-1/ref=pd_bbs_b_2_1/103-7238308-7102208?s=books&v=glance&n=283155

NOTE: Celko wrote the Forward to this book - AND the book refers to columns
as fields!!! LOL!!!

Show quote

"JD" <J*@discussions.microsoft.com> wrote in message
news:ACA8DD1C-E62E-4AA3-910F-82EEEA6CC2F7@microsoft.com...
> Im trying to write a complicated SQL in analyser using several tables and
> sub
> selects to do some inserts.
>
> I have to do this very often and I only have a limited knowledge of SQL.
>
> Can you recommend a book I can go out and buy that will teach me how to
> write involved SQLs for a beginner please.
>
> (The name and author would be great).
>
> Thanks, confused and frustrated!
>
>