Recomend SQL Book
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
|