first_page the funky knowledge base
personal notes from way, _way_ back and maybe today

Explicit Join Syntax and Implicit Join Syntax

SQL specifies two different syntactical ways to express joins. The first, called "explicit join notation", uses the keyword JOIN, whereas the second uses the "implicit join notation". The implicit join notation lists the tables for joining in the FROM clause of a SELECT statement, using commas to separate them. Thus, it specifies a cross-join, and the WHERE clause may apply additional filter-predicates. Those filter-predicates function comparably to join-predicates in the explicit notation.

[http://en.wikipedia.org/wiki/Join_(SQL)]

mod date: 2010-03-20T05:35:20.000Z