[thelist] SQL: looking for resources, have one question

Mon Oct 21 15:55:01 CDT 2002

At 12:05 PM 10/21/02, you wrote:
>LOL, yes, Chris is a very underutilized name. :)
>
>I imagine Access bawked at the INNER JOIN syntax for one reason or another.
>What error did you get?  I'm not even positive it's directly supported
>within Access... (damn Access).

         Access only supports Jet-SQL, a custom Microsoft subset of SQL. I
believe it's described both on the MSDN (msdn.microsoft.com) and DevGuru.

         In addition, DevGuru is my personal favorite SQL resource. As far
as "quick reference" goes, it has great T-SQL (standard for "Transact-SQL,"
which is a more advanced SQL) "syntax charts," which basically explains how
everything should work. However, I'd recommend looking at it in IE so that
you can get the tooltips that appear over all the syntax elements.

         http://www.devguru.com

         The syntax charts are specifically at:
http://www.devguru.com/Technologies/sqlsyntax/quickref/sql_syntax_intro.html
         The Jet-SQL (which is what Access supports) reference is at:
http://www.devguru.com/Technologies/jetsql/quickref/jet_sql_intro.html

         -M