Linux and Open Source... What is still missing?

[Derek Broughton]

Jan Claeys wrote:

> Op woensdag 25-10-2006 om 12:30 uur [tijdzone -0300], schreef Derek
> Broughton:
>> afaik, Access conforms to ANSI SQL standards.
> 
> IME Access's default Jet DB Engine doesn't use standards compliant
> SQL... (and neither does MS SQL Server).
> 
> (But this was mostly about 5-6 years ago.)

It (Access - no idea about SQL Server) is certainly more ANSI compliant than
Oracle was 5-6 years ago.  Oracle's improved, but I still find when a query
written for Oracle doesn't work in Access, it's because the oracle query is
not ANSI SQL.
-- 
derek