Performing SELECT Statements that Use More than Two Tables : Introduction « Table Joins « Oracle PL/SQL Tutorial






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

Joins can be used to connect any number of tables.

The number of joins you will need in your WHERE clause is total_number_of_tables - 1

There are two types of join conditions, which are based on the operator.

Equijoins - You use the equality operator (=) in the join.

Non-equijoins - You use an operator other than equals in the join, such as <, >, BETWEEN, and so on.









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