# pg\_catalog

Published articles for pg\_catalog.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Using jOOQ's Implicit Join From Within the JOIN .. ON Clause

DevFeed: [Using jOOQ's Implicit Join From Within the JOIN .. ON Clause](<https://devfeed.tech/articles/using-jooq-s-implicit-join-from-within-the-join-on-clause-28970.md>)

Original publisher: [Read original article](<https://blog.jooq.org/using-jooqs-implicit-join-from-within-the-join-on-clause/>)

Author: lukaseder

Published: 2022-09-13T07:29:59Z

Content type: tutorial

Language: en

Sources: [jOOQ](<https://devfeed.tech/sources/jooq.md>)

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>)

Tags: [dictionary-views](<https://devfeed.tech/tags/dictionary-views.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [implicit-join](<https://devfeed.tech/tags/implicit-join.md>), [information-schema](<https://devfeed.tech/tags/information-schema.md>), [jooq](<https://devfeed.tech/tags/jooq.md>), [jooq-3-17](<https://devfeed.tech/tags/jooq-3-17.md>), [jooq-in-use](<https://devfeed.tech/tags/jooq-in-use.md>), [pg-catalog](<https://devfeed.tech/tags/pg-catalog.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [technical](<https://devfeed.tech/tags/technical.md>)

### AI overview

This tutorial explains how to use jOOQ's type-safe implicit JOINs from within an explicit JOIN ... ON clause. It uses PostgreSQL dictionary views and related tables as an example, and describes how jOOQ generates SQL while preserving operator precedence.

### Source excerpt

Starting with jOOQ 3.11, type safe implicit JOIN have been made available, and they've been enhanced to be supported also in DML statements in jOOQ 3.17. Today, I'd like to focus on a somewhat weird but really powerful use-case for implicit JOIN, when joining additional tables from within an explicit JOIN's ON clause. The use ... Continue reading Using jOOQ's Implicit Join From Within the JOIN .. ON Clause ->