The Outer Limits of SQL JOINs
Subject:   inner joins
Date:   2001-10-01 18:22:25
From:   dragonstep
Won't most database vendors optomize the join
with the where clause so it defaults to an
inner join?


Main Topics Newest First

Showing messages 1 through 1 of 1.

  • inner joins
    2002-03-25 03:34:05  celaia [View]

    The ANSI-SQL92 (SQL2) Join syntax already is implemented in
    - ASA (since version 5; current version 8)
    - ASE (since version 12; current version 12.5)
    - Oracle (since version 9i; current version 9i)
    - DB2 (since version 7)
    - MS-SQL (since version 6.5; current version 8 (2000))

    Most of the editors recommend that applications use ANSI outer joins because they unambiguously specify whether the on or where clause contains the predicate, which is ambiguous when you use the pre-ANSI syntax of joins.