USING clause

A join shorthand that pairs rows on columns with the same name in both tables, such as USING (category_id).

In more detail

It is fine when both columns really share a name. The course's tables use id on one side and customer_id on the other, so the pairing rule has to be written with ON.

Related terms

Taught in

References