NATURAL JOIN

Equi-joins

Using multiple tables in a query

Intersect and Except

Conventional set-theoretic operations and the SELECT statement