View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 1,726
Default 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