LOOKING FOR COMPREHENSIVE DOCUMENTATION FOR MICROSOFT JET SQL

[TNN]

I'm going bananas. I look up syntax in any ANSI SQL documentation I have and then can't make it work in MS Jet SQL. When I try to find the MS Jet SQL equivalent I have to search through MSDN and MS Acess. Sometimes I come up with the answers and sometimes not. Microsoft Access is really lacking in documentation of SQL syntax.

I am currently trying to construct subqueries and the ANSI syntax doesn't work in MS Jet SQL.

Can someone please help. Doesn't this big multi-billion dollar outfit have some single place where ALL the MS Jet SQL syntax is documented and can be referenced.

Maybe someone that uses MS Jet SQL in depth can help me.

Thank You to any-body in advance
TNPAYROLL@AOL.COM

TOM

http://WWW.TNPAYROLL@AOL.COM

 

[Amiel]

MS Jet supports a subset of SQL 89 and some elements of SQL 92.

Try typing the keyword on the 'index' tab in the Access help file.


Amiel
amielzz@netscape.net

 

[TNN]

Hi Amiel,
I Don't see any index tab in Acess 2000, only the little paper clip guy. If I go to MSDN index, there I find the exact same thing I find in Access with no expansion on the syntax explanation. Thank you for your input Amiel.
TNN, Tom
TNPAYROLL@AOL.COM

TOM

http://WWW.TNPAYROLL@AOL.COM