Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

Outer Join Predicate

Description

An outer join predicate specifies two tables and returns a result table that contains all of the rows from one of the tables, even if there is no matching row in the other table. See Outer Joins for more information.

Syntax

outer_join_predicate ::

[ table_name. ] column = [ table_name. ] column (+)

| [ table_name. ] column (+) = [ table_name. ] column

TOCIndex