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

3.7.1.

Generated Tables

3.7.2.

Aliased Tables

3.7.2.1.

Aliased generated tables

3.7.2.2.

Aliased table expressions

3.7.2.3.

Derived column lists

3.7.2.4.

Unnamed derived tables

3.7.3.

Joined tables

3.7.3.1.

CROSS JOIN

3.7.3.2.

INNER JOIN

3.7.3.3.

OUTER JOIN

3.7.3.4.

SEMI JOIN

3.7.3.5.

ANTI JOIN

3.7.3.6.

ON clause

3.7.3.7.

ON KEY clause

3.7.3.8.

USING clause

3.7.3.9.

NATURAL clause

3.7.3.10.

LATERAL

3.7.3.11.

APPLY

3.7.3.12.

PARTITION BY

3.7.4.

The VALUES() table constructor

3.7.5.

Derived tables

3.7.6.

Inline derived tables (new)

3.7.7.

The Oracle PIVOT clause

3.7.8.

Relational division

3.7.9.

Array and cursor unnesting

3.7.10.

Table-valued functions

3.7.11.

GENERATE_SERIES

3.7.12.

The DUAL table