Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables from Skillsoft

Explore how to join tables together to view information across multiple tables and examine the more advanced features of the SELECT statements.

Learning Objectives

Oracle Database 12c R2 SQL: Displaying Data from Multiple Tables

obtain data from multiple tables
list the various types of joins
use the NATURAL JOIN clause
use the USING clause to specify columns used for an equijoin to retrieve records in a SQL statement
join tables with the ON clause
use self-joins using the ON clause
use a join condition containing a nonequijoin in a SQL statement
use a left, right, and full outer join in a SQL statement
demonstrate the generation of a Cartesian product returned by a SQL statement
create cross joins in a SQL statement
access data from multiple tables