Books covering Access SQL peculiarities

[_DS]

I'm not a SQL programmer, but I have about 10 books on SQL, mostly for
SQL server. Just spent way too much time trying to figure out why a
'compound' inner join didn't work in Access (many-to-many using a link
table to join something like 'Authors' and 'Books'). It's tough
enough to find mention of link tables, but the sticky point with
Access was that it required parens. Those are not used in any of the
sample code I've seen.

So...I'd like to find a simple reference that outlines Access SQL's
syntactical differences (vs SQL Server dialect). Does that exist?

 

[_DS]

I'm not a SQL programmer, but I have about 10 books on SQL, mostly for
SQL server. Just spent way too much time trying to figure out why a
'compound' inner join didn't work in Access (many-to-many using a link
table to join something like 'Authors' and 'Books'). It's tough
enough to find mention of link tables, but the sticky point with
Access was that it required parens. Those are not used in any of the
sample code I've seen.

So...I'd like to find a simple reference that outlines Access SQL's
syntactical differences (vs SQL Server dialect). Does that exist?

No replies yet. Well, maybe I shouldn't have said 'peculiarities' but
you know what I mean. Are there any books that concentrate on
differences between Access's SQL dialect and that of SQL Server?
If not, how about books that just cover Access SQL in general?

 

[Duane Hookom]

Check here http://www.viescas.com/Info/books.htm to find the book by
Hernandez and Viescas. It's a great combination of authors and probably the
best book on Access queries.

 

[_DS]

Check here http://www.viescas.com/Info/books.htm to find the book by
Hernandez and Viescas. It's a great combination of authors and probably the
best book on Access queries.

Thanks, Duane. I already have one of Hernandez's books, and was
considering that one. If it covers Access SQL then I guess I've got
to get it.

 

[Duane Hookom]

Michael Hernandez has two books of interest for this. One isn't real
specific to Access while the one with John Viescas as a co-author is.