Thanks for your answer.

If you don't mind I've got a new one.

So, if I understand well, that means Oracle is not Ansi-92 compliant.

Thanks,

Louis


-----Original Message-----
From: Ken Schaefer [mailto:ken@a...]
Sent: 14 mai, 2001 04:18
To: sql language
Subject: [sql_language] Re: JOIN in Oracle vs MSSql


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: As you may know, Oracle does not accept the word JOIN a query but MsSql
: does. And it does a query on two tables with a different syntax than in
: MsSql. Why is it like this and I wonder wich one is ANSI-92 compliant and
: which syntax is better to use.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

ANSI-92 moved the JOIN syntax to the FROM clause aka:

SELECT
FROM table1
[JOIN TYPE] JOIN table2
ON table1.ID = table2.ID

The older style JOIN (in the WHERE clause) was retained for backwards
compatability:

SELECT
FROM table1, table2
WHERE table1.ID = table2.ID

Cheers
Ken