5.1. Join Syntax: Out with the Old and In with the New (SQL:1999)
Not only can you join two or more tables in a number of different ways, but you can also use two different syntax forms to perform these joins. As of Oracle9i, the full ANSI SQL:1999 standard for join syntax is supported. Prior to Oracle9i, Oracle used a proprietary syntax that wasn't always compatible with the ANSI standard.
join
To combine two or more tables in a query to produce rows as a result of a comparison between columns in the tables.
Oracle's proprietary syntax, which is still supported in Oracle9i and Oracle 10g for backward compatibility with existing code, put all of the join conditions in the SELECT statement's WHERE clause. It also relied on relatively obscure ...
Get Oracle Database Foundations now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
