Syntax

• Usually best to put the join conditions first in the WHERE clause

• Use of aliases greatly simplifies the statement.

• Any logical operator can be used.

• A self-join can be performed on the same table by qualifying it twice.

Previous slide

Next slide

Back to first slide

View graphic version