join operator

Comparison operator in a join condition that determines how the two sides of the condition are evaluated and which records are returned.