Specifies join conditions for joins preformed using the JOIN keyword, creates a pattern join condition, or used to identify the trigger which causes rows to be deleted, updated, or inserted into a named window, or which causes variables to change state.
The following subsections describe three syntax variations of the ON clause. The first syntax variation is used to specify join conditions for joins performed using the JOIN keyword. The second syntax variation is used in pattern definition, with the MATCHING clause, to create a pattern join condition. The third syntax variation is used with a Delete statement, Set Variable statement, or Update Window statement, or to identify the trigger which causes rows to be deleted, updated, or inserted into a named window, or which causes variables to change state.
ON Clause: Join Syntax
ON Clause: Pattern Matching Syntax
ON Clause: Trigger Syntax