Books covering Access SQL peculiarities

  • Thread starter Thread starter _DS
  • Start date Start date
D

_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?
 
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?
Click to expand...

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?
 
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.
 
Back
Top