Recomend SQL Book

[Phil]

I'm using Access 2003 and my Queries are getting very complex. I need to
teach myself SQL. What book(s) would you recommend.

Thanks.

Phil

 

[Dave F]

First thing I would recommend is posting this question in an Access news
group. This newsgroup is for Excel.

Dave

 

[Bob Phillips]

The big problem is that most Access books are about Access, with a bit of
SQL chucked in. The next problem is that they move into teaching you how to
write SQL, the syntax etc.

I use O'Reilly's Transact-SQL Programming, but that flavour of SQL is
SQL-Server and Sybase specific, so probably doesn't suit.

Martin Green recommends

SQL: Access to SQL Server
Susan Sales Harkins, Martin Reid
Apress ISBN: 1893115305

but that seems more like a migration tome. It sounds that you want to have a
problem solving book that uses SQL as the tool. Maybe

SQL Queries for Mere Mortals (English)
(A Hands-On Guide to Data Manipulation in SQL - ISBN: 0201433362)

Publisher: Addison-Wesley



or

SQL Cookbook

By Anthony Molinaro

or

Access Database Design and Programming, Second Edition

By Steven Roman, Ph.D.

Those are not recommendations, I have only read the one, and I have no
vested interest in any of them.


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Jon Peltier]

This week I needed SQL help, and got a lot through a combination of 'SQL for
Dummies' and Google (which is like 'Everything for Dummies').

- Jon