In a Join, when is the ON clause required?
If the Join is a SELF JOIN.
Only if the WHERE clause is not used.
If the keyword INNER is specified.
all the time.