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?
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?