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

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

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Phil" wrote:

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

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)



"Phil" wrote in message
...
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

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Phil" wrote in message
...
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