Women in Technology

Hear us Roar



Article:
  The Outer Limits of SQL JOINs
Subject:   inner joins
Date:   2002-03-25 03:34:05
From:   celaia
Response to: inner joins

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.