Understanding Non-equijoins : Introduction « Table Joins « Oracle PL/SQL Tutorial






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

A non-equijoin uses an operator other than the equality operator in the join.

Examples of non-equality operators are:

  1. not-equal (<>),
  2. less than (<),
  3. greater than (>),
  4. less than or equal to (<=),
  5. greater than or equal to (>=),
  6. LIKE,
  7. IN, and
  8. BETWEEN.








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