A condition that refers to left and right sources using equality, so may be rewritten into the join condition.
A condition which refers only to the left source
An expression that doesn't refer to any source.
A condition which refers to both sources but doesn't have the right shape to become the join condition.
A condition which refers only to the right source.