Three different types of joins: : Introduction « Table Joins « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Table Joins
  3. Introduction

Inner joins - Return a row only when the columns in the join contain values that satisfy the join condition.

This means that if a row has a null value in one of the columns in the join condition, that row isn't returned.

Outer joins - Can return a row even when one of the columns in the join condition contains a null value.

Self joins - Return rows joined on the same table.









7.1.Introduction
7.1.1.Performing SELECT Statements that Use More than Two Tables
7.1.2.Three different types of joins:
7.1.3.Understanding Non-equijoins
7.1.4.Performing SELECT Statements that Use Two Tables
7.1.5.Example simple join.
7.1.6.Use table alias in table join
7.1.7.Convert subqueries to JOINs
7.1.8.autotrace ansi full outer join