O'Reilly logo

OCA Oracle Database SQL Exam Guide (Exam 1Z0-071) 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

Images

8

Displaying Data from Multiple Tables

CERTIFICATION OBJECTIVES

8.01     Describe the Different Types of Joins and Their Features

8.02     Write SELECT Statements to Access Data from More Than One Table Using Equijoins and Non-Equijoins

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

8.04     View Data That Generally Does Not Meet a Join Condition by Using Outer Joins

   ✓        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 to return a merged set of rows. To accomplish the join, the SELECT statement specifies ...

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