What is the difference between the ON clause and the WHERE
clause?

Question

Answer

In outer joins, the ON clause determines filtering and
the WHERE clause determines matching.

Answer

The ON clause uses three-valued logic and the WHERE
clause uses two-valued logic

Answer

The ON clause uses two-valued logic and the
WHERE clause uses three-valued logic.

Answer

In outer joins, the ON clause determines
matching and the WHERE clause determines filtering

Crowdly