Posted by Erland Sommarskog on 04/27/06 00:34

(alanenglefield@gmail.com) writes:
> You're right of course, it is in Access but it is just the SQL
> statement that I had a query with and I thought that all forms of SQL
> were a standard syntax. (I did say I was a newbie)

You are right as far that there is a standard for SQL. There are in fact
several revisions of it. However, few RDBMS inmplements all of the standard,
even not of the earlier revisions. At the same time time many RDBMS have
their own extensions.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]