Can anyone recommend any good reference books for learning SQL.
But only as it relates to Access (baby SQL as it's referred to at work).
Any recommendations greatly received.
Thanks,
Jason
Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html
The Access Web resources page:
http://www.mvps.org/access/resources/index.html
Most of the Access books at least touch on SQL query design, but I'm not aware
of any books that specifically cover nothing but Access SQL.
There are dialect differences between the SQL used in Access, SQL/Server,
MySQL, Oracle etc., but they aren't foreign languages. Access is picky about
parentheses in JOIN expressions, for instance; and there are some things you
can't do directly, such as COUNT DISTINCT. But any ANSI standard SQL language
tutorial would give you the vast bulk of what you need. Even the SQL/Server
BOL SQL syntax pages will help, just so you don't get into the full T-SQL
"program language" syntax.
John W. Vinson [MVP]
