Oracle Programming/Displaying Data from Multiple Tables

Writing SELECT statements to access data from more than one table using equijoins and nonequijoins

Joining a table to itself by using a self-join

Viewing data that generally does not meet a join condition by using outer joins

Generating a Cartesian product of all rows from two or more tables