Search code examples
sqloracle-databaseansi-sql

Are Oracle Equi-joins ANSI Compliant

I had a quick Google but couldn't find a question and an answer which answers this directly.

Are equi-joins like this ANSI compliant: 

t1.a = t2.a
t2.b = t3.b
Solution

  • What you show is not joins, it's conditions.

    This is an equi join as of SQL-86:

    select *
from a, b
where a.x = b.x;

    This is an equi join as of SQL-92:

    select *
from a
inner join b on a.x = b.x;

    So both are ANSI compliant joins. The first one has always been; the second one only for little more than 20 years.