Image
CERTIFICATION OBJECTIVES
7.01    Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
7.02    Join a Table to Itself Using a Self-Join
7.03    View Data that Does Not Meet a Join Condition Using Outer Joins
7.04    Generate a Cartesian Product of Two or More Tables
  Image      Two-Minute Drill
Q&A   Self Test
 
The three pillars of relational theory are selection, projection, and joining. This chapter focuses on the practical implementation of joining. Rows from different tables are associated with each other ...

Get OCA Oracle Database 11g SQL Fundamentals I Exam Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.