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

Maxwell Kanat-Alexander maxka at cats.ucsc.edu
Mon Oct 21 15:50:01 CDT 2002


[ Converted text/html to text/plain ]
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[1]
        The syntax charts are specifically at:
http://www.devguru.com/Technologies/sqlsyntax/quickref/sql_syntax_intro.html[2]
        The Jet-SQL (which is what Access supports) reference is at:
http://www.devguru.com/Technologies/jetsql/quickref/jet_sql_intro.html[3]
        -M

===References:===
  1. http://www.devguru.com/
  2. http://www.devguru.com/Technologies/sqlsyntax/quickref/sql_syntax_intro.html
  3. http://www.devguru.com/Technologies/jetsql/quickref/jet_sql_intro.html




More information about the thelist mailing list