Hello Thomas,
venerdì, 11 dicembre 98, you wrote:
>> Microsoft SQL Server v6.5 have SQL92 join syntax. I don't have the
>> standard in front of me but here's what I remember.
TGL> OK, it's pretty clear that Oracle doesn't implement SQL92-syntax on
TGL> outer joins (unless they support it as an alternative; does anyone find
TGL> "OUTER JOIN" in the syntax docs?).
TGL> Let's assume that M$ may be close to standard, but given that they don't
TGL> bother following standards in other areas (WHERE x = NULL, etc) we can't
TGL> use them as a truth generator.
TGL> We are looking for a system which supports syntax like DeJuan gave:
TGL> SELECT * FROM (A LEFT OUTER JOIN B USING (X));
TGL> or
TGL> SELECT * FROM (A LEFT OUTER JOIN B ON (A.X = B.X));
TGL> etc. if we are going to try for the SQL92 standard,
TGL> rather than the Oracle form:
TGL> SELECT * FROM A, B WHERE A.X = (+) B.X;
TGL> or the Informix form:
TGL> SELECT * FROM A, OUTER B WHERE A.X = B.X;
TGL> (is the WHERE clause required here?)
TGL> Does anyone have a non-M$ RDBMS which implements SQL92 joins?
Download OCELOT for Win32 at http://ourworld.compuserve.com/homepages/OCELOTSQL
their database implements SQL92 joins.
Their home page says:
Ocelot makes the only Database Management System (DBMS) that supports
the full ANSI / ISO SQL Standard (1992).
...
This is also the only place on the Net where you can find documentation
that explains and provides examples of the full SQL-92 standard. This is version 1.0.
I'm trying it, is very interesting but it is only for M$-win.
-Jose'-