CHAPTER 10
SQL Joins
Exam Objectives
• 061.6.1 Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Nonequijoins
• 061.6.2 Join a Table to Itself Using a Self-Join
• 061.6.3 View Data that Does Not Meet a Join Condition Using Outer Joins
• 061.6.4 Generate a Cartesian Product of Two or More Tables
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 using joins. Support for joining has implications for the way data is stored in database tables. Many data ...
Get OCA/OCP Oracle Database 12c All-in-One Exam Guide (Exams 1Z0-061, 1Z0-062, & 1Z0-063), 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
