Table expressions

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

The following sections explain the various types of table expressions supported by jOOQ

Table of contents

4.7.1.

Generated Tables

4.7.2.

Aliased Tables

4.7.3.

Joined tables

4.7.3.1.

CROSS JOIN

4.7.3.2.

INNER JOIN

4.7.3.3.

OUTER JOIN

4.7.3.4.

SEMI JOIN

4.7.3.5.

ANTI JOIN

4.7.3.6.

ON clause

4.7.3.7.

ON KEY clause

4.7.3.8.

USING clause

4.7.3.9.

NATURAL clause

4.7.3.10.

APPLY or LATERAL

4.7.3.11.

PARTITION BY

4.7.4.

The VALUES() table constructor

4.7.5.

Derived tables

4.7.6.

The Oracle 11g PIVOT clause

4.7.7.

jOOQ's relational division syntax

4.7.8.

Array and cursor unnesting

4.7.9.

Table-valued functions

4.7.10.

The DUAL table