Keeps all records from the right side.

Function combining multiple values.

Normalization removing partial dependencies.

Named field in a database table.

Keeps records from both sides.

Function returning one value.

Normalization removing transitive dependencies.

Column or columns uniquely identifying records.

Produces Cartesian combinations.

Variant of SQL syntax and features.