The Difference Between SQL’s JOIN .. ON Clause and the Where Clause

1818 shaares
37 private links

1818 shaares · 37 private links

Filters

Links per page

20 50 100

The Difference Between SQL’s JOIN .. ON Clause and the Where Clause – Java, SQL and jOOQ.

For INNER JOIN, WHERE predicates and ON predicates have the same effect.
For OUTER JOIN, WHERE predicates and ON predicates have a different effect.

SQL · Join

Filters

Links per page

20 50 100