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

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