Relational operators list

<< Click to Display Table of Contents >>

Navigation:  Local SQL > Data Manipulation Language > Relational operators >

Relational operators list

 Previous pageReturn to chapter overviewNext page

 

Local SQL supports the following join types:

Join operator
Description

Equi-join
Joins two tables, filtering out non-matching rows.

INNER
Joins two tables, filtering out non-matching rows.

OUTER
Joins two tables, retaining non-matching rows.

Cartesian
Joins two tables, matching each row of one table with each row from the other.

UNION
Concatenates the result set of one query with the result set of another query.

Heterogeneous
Joins two tables in different databases, including differing database types.