All versions: 3.11 | 3.10 | 3.9 | 3.8 | 3.7 | 3.6 | Development versions: 3.12

In some occasions, you may prefer the INSERT SELECT syntax, for instance, when you copy records from one table to another:

create.insertInto(AUTHOR_ARCHIVE)
      .select(selectFrom(AUTHOR).where(AUTHOR.DECEASED.isTrue()))
      .execute();
The jOOQ Logo