Re[2]: [HACKERS] JOIN syntax. Examples?

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'-