comma join

The old join syntax that lists tables separated by commas in FROM and puts the pairing rule in WHERE.

In more detail

It works, but the rule sits far from the table it belongs to and is easy to forget, which produces a Cartesian product. Prefer explicit JOIN with ON.

Example

FROM customers, orders   -- no rule: every pair

Related terms

Taught in

References