O'Reilly logo

OCA Oracle Database SQL Expert Exam Guide by Steve O'Hearn

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required