Available in versions: Dev (3.19) | Latest (3.18) | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9

This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.

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

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.: jOOQ's relational division syntax
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

previous : next

Feedback

Do you have any feedback about this page? We'd love to hear it!

Tell us a little bit about yourself and join our newsletter (examples)

Table expressions

Table of contents

References to this page

Feedback

Community

Support

Legal

Documentation