# jOOQ 3.17 Supports Implicit Join also in DML

DevFeed: [jOOQ 3.17 Supports Implicit Join also in DML](<https://devfeed.tech/articles/jooq-3-17-supports-implicit-join-also-in-dml-28950.md>)

Original publisher: [Read original article](<https://blog.jooq.org/jooq-3-17-supports-implicit-join-also-in-dml/>)

Author: lukaseder

Published: 2022-08-25T08:07:00Z

Content type: article

Language: en

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

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

Tags: [correlated-subqueries](<https://devfeed.tech/tags/correlated-subqueries.md>), [delete](<https://devfeed.tech/tags/delete.md>), [dml-join](<https://devfeed.tech/tags/dml-join.md>), [implicit-join](<https://devfeed.tech/tags/implicit-join.md>), [join](<https://devfeed.tech/tags/join.md>), [jooq](<https://devfeed.tech/tags/jooq.md>), [jooq-3-17](<https://devfeed.tech/tags/jooq-3-17.md>), [jooq-development](<https://devfeed.tech/tags/jooq-development.md>), [mariadb](<https://devfeed.tech/tags/mariadb.md>), [mysql](<https://devfeed.tech/tags/mysql.md>), [oracle](<https://devfeed.tech/tags/oracle.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [sql](<https://devfeed.tech/tags/sql.md>), [update](<https://devfeed.tech/tags/update.md>)

## AI overview

The article explains that jOOQ 3.17 adds support for implicit join path expressions in DML statements. It describes correlated-subquery emulation, DML JOIN support for selected RDBMS, and planned translation using updatable views in Oracle.

## Source excerpt

Since jOOQ 3.11, implicit joins have been supported. An implicit join is a JOIN (mostly a LEFT JOIN) that is generated implicitly because of the presence of a path expression. If SQL supported the syntax natively, it would look like this: All that is is convenience for a bunch of explicitly written LEFT JOIN expressions: ... Continue reading jOOQ 3.17 Supports Implicit Join also in DML ->