SQL-92 Join Syntax
SQL-92 provides some keywords for joins (JOIN, CROSS JOIN, and NATURAL JOIN, which can be combined with INNER, RIGHT OUTER, LEFT OUTER, and FULL OUTER to make the full spectrum of joins). Some or all of these keywords are implemented by an increasing number of systems, including the Adaptive Server Anywhere included with this book. However, the original FROM/WHERE join syntax is still common, and vendors that support the new JOIN keyword syntax also provide it. For this reason, most of the examples in this chapter use the original FROM/WHERE syntax. Examples of the new syntax are provided as translations—the concepts are not different, only the annotation is.
Following are some ANSI syntax alternatives. The FROM clause includes ...
Get Practical SQL Handbook, The: Using SQL Variants, Fourth Edition 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.
