8Displaying Data from Multiple Tables

CERTIFICATION OBJECTIVES

8.01 Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Non-Equijoins/View Data That Generally Does Not Meet a Join Condition by Using Outer Joins

8.02 Join a Table to Itself by Using a Self-Join

8.03 Generate a Cartesian Product of All Rows from Two or More Tables

image Two-Minute Drill

Q&A Self Test

This chapter reviews various types of joins. A join is a SELECT statement that retrieves data from two or more tables and connects that data together to produce a combined set of output. The SELECT statement specifies data in one table that is identical to data ...

Get OCA Oracle Database SQL Certified Expert Exam Guide (Exam 1Z0-047) 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.

Start your free trial