On

ON

This keyword is using as ON parameter in SET statement and as join condition in JOIN

Syntax:

    SET option ON;
    SELECT ... FROM t1 JOIN t2 ON t1.col1 = t2.col1 AND t2.col2 = t2.col2;

See also: OFF, USING