The join operations that do not retain mismatched tuples are called as inner join operations. The inner join operation does not preserve any tuples on either side of the relation.

The on condition is a part of the outer join syntax but the where clause isn’t.

The full outer join operation preserves the tuples named on both the sides of the operation. Unlike the inner join, outer joins preserve tuples from either or both sides of the operation.

The left outer join operation preserves the tuples named before the operation.

The join operations that do not retain mismatched tuples are called as inner join operations. The inner join operations do not preserve any tuples that are otherwise preserved in the outer join operation.

The right outer join operation preserves the tuples named after the operation.

If a left outer join is performed and the tuple on the left hand side does not match with the tuple on the right hand side, the remaining values are given a null value.

The outer join operation preserves a few tuples that are otherwise lost in the join operation. The outer join operation preserves the tuples to the right of the operation.

The on condition appears at the end of the join expression. Because it states the condition that the relations under the join operations get matched based on.

There is no such join called as full join. There is a full outer join but a full join does not exist.