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.10.1.

Generated Tables

4.10.2.

Aliased Tables

4.10.2.1.

Aliased generated tables

4.10.2.2.

Aliased table expressions

4.10.2.3.

Aliased joined tables

4.10.2.4.

Derived column lists

4.10.2.5.

Unnamed derived tables

4.10.3.

Joined tables

4.10.3.1.

CROSS JOIN

4.10.3.2.

INNER JOIN

4.10.3.3.

OUTER JOIN

4.10.3.4.

SEMI JOIN

4.10.3.5.

ANTI JOIN

4.10.3.6.

ON clause

4.10.3.7.

ON KEY clause

4.10.3.8.

USING clause

4.10.3.9.

NATURAL clause

4.10.3.10.

LATERAL

4.10.3.11.

APPLY

4.10.3.12.

PARTITION BY

4.10.3.13.

JOIN hints (new)

4.10.3.13.1.

HASH JOIN (new)

4.10.3.13.2.

LOOP JOIN (new)

4.10.3.13.3.

MERGE JOIN (new)

4.10.4.

The VALUES() table constructor

4.10.5.

Derived tables

4.10.6.

Inline derived tables

4.10.7.

The Oracle 11g PIVOT clause

4.10.8.

Relational division

4.10.9.

Array and cursor unnesting

4.10.10.

Table-valued functions

4.10.11.

GENERATE_SERIES

4.10.12.

WITH ORDINALITY

4.10.13.

JSON_TABLE

4.10.14.

XMLTABLE

4.10.15.

The DUAL table

4.10.16.

Temporal tables

4.10.17.

Data change delta tables