Top Description Methods
org.jooq

public Interface SelectJoinStep<R extends org.jooq.Record>

extends SelectWhereStep<R extends Record>
Known Direct Subinterfaces
org.jooq.SelectOnConditionStep, org.jooq.SelectOptionalOnStep
Static Imports
org.jooq.SQLDialect.CUBRID, .SQLDialect.DERBY, .SQLDialect.FIREBIRD, .SQLDialect.H2, .SQLDialect.HSQLDB, .SQLDialect.IGNITE, .SQLDialect.MARIADB, .SQLDialect.MYSQL, .SQLDialect.POSTGRES, .SQLDialect.SQLITE, .SQLDialect.YUGABYTEDB
This type is used for the Select's DSL API when selecting generic Record types.

Example: 


-- get all authors' first and last names, and the number
-- of books they've written in German, if they have written
-- more than five books in German in the last three years
-- (from 2011), and sort those authors by last names
-- limiting results to the second and third row

  SELECT T_AUTHOR.FIRST_NAME, T_AUTHOR.LAST_NAME, COUNT(*)
    FROM T_AUTHOR
    JOIN T_BOOK ON T_AUTHOR.ID = T_BOOK.AUTHOR_ID
   WHERE T_BOOK.LANGUAGE = 'DE'
     AND T_BOOK.PUBLISHED > '2008-01-01'
GROUP BY T_AUTHOR.FIRST_NAME, T_AUTHOR.LAST_NAME
  HAVING COUNT(*) > 5
ORDER BY T_AUTHOR.LAST_NAME ASC NULLS FIRST
   LIMIT 2
  OFFSET 1
     FOR UPDATE
      OF FIRST_NAME, LAST_NAME
      NO WAIT
Its equivalent in jOOQ 

create.select(TAuthor.FIRST_NAME, TAuthor.LAST_NAME, create.count())
      .from(T_AUTHOR)
      .join(T_BOOK).on(TBook.AUTHOR_ID.equal(TAuthor.ID))
      .where(TBook.LANGUAGE.equal("DE"))
      .and(TBook.PUBLISHED.greaterThan(parseDate('2008-01-01')))
      .groupBy(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
      .having(create.count().greaterThan(5))
      .orderBy(TAuthor.LAST_NAME.asc().nullsFirst())
      .limit(2)
      .offset(1)
      .forUpdate()
      .of(TAuthor.FIRST_NAME, TAuthor.LAST_NAME)
      .noWait();
Refer to the manual for more details

Referencing XYZ*Step types directly from client code

It is usually not recommended to reference any XYZ*Step types directly from client code, or assign them to local variables. When writing dynamic SQL, creating a statement's components dynamically, and passing them to the DSL API statically is usually a better choice. See the manual's section about dynamic SQL for details: https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql.

Drawbacks of referencing the XYZ*Step types directly:

Author
Lukas Eder

Method Summary

Modifier and TypeMethod and Description
public @NotNull SelectJoinStep<R>
crossApply(TableLike<?> table)

CROSS APPLY a table to this table.

public @NotNull SelectJoinStep<R>
crossApply(SQL sql)

CROSS APPLY a table to this table.

public @NotNull SelectJoinStep<R>
crossApply(String sql)

CROSS APPLY a table to this table.

public @NotNull SelectJoinStep<R>
crossApply(String sql, Object... bindings)

CROSS APPLY a table to this table.

public @NotNull SelectJoinStep<R>
crossApply(String sql, QueryPart... parts)

CROSS APPLY a table to this table.

public @NotNull SelectJoinStep<R>
crossApply(Name name)

CROSS APPLY a table to this table.

public @NotNull SelectJoinStep<R>
crossJoin(TableLike<?> table)

Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table#crossJoin(TableLike)

If this syntax is unavailable, it is emulated with a regular INNER JOIN.

public @NotNull SelectJoinStep<R>
crossJoin(SQL sql)

Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table#crossJoin(String)

If this syntax is unavailable, it is emulated with a regular INNER JOIN.

public @NotNull SelectJoinStep<R>
crossJoin(String sql)

Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table#crossJoin(String)

If this syntax is unavailable, it is emulated with a regular INNER JOIN.

public @NotNull SelectJoinStep<R>
crossJoin(String sql, Object... bindings)

Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table#crossJoin(String, Object...)

If this syntax is unavailable, it is emulated with a regular INNER JOIN.

public @NotNull SelectJoinStep<R>
crossJoin(String sql, QueryPart... parts)

Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table#crossJoin(String, QueryPart...)

If this syntax is unavailable, it is emulated with a regular INNER JOIN.

public @NotNull SelectJoinStep<R>
crossJoin(Name name)

Convenience method to CROSS JOIN a table to the last table added to the FROM clause using Table#crossJoin(Name)

If this syntax is unavailable, it is emulated with a regular INNER JOIN.

public @NotNull SelectOnStep<R>
fullJoin(TableLike<?> table)

Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table#fullOuterJoin(TableLike).

public @NotNull SelectOnStep<R>
fullJoin(SQL sql)

Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table#fullOuterJoin(String).

public @NotNull SelectOnStep<R>
fullJoin(String sql)

Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table#fullOuterJoin(String).

public @NotNull SelectOnStep<R>
fullJoin(String sql, Object... bindings)

Convenience method to FULL OUTER JOIN a tableto the last table added to the FROM clause using Table#fullOuterJoin(String, Object...).

public @NotNull SelectOnStep<R>
fullJoin(String sql, QueryPart... parts)

Convenience method to FULL OUTER JOIN a tableto the last table added to the FROM clause using Table#fullOuterJoin(String, QueryPart...).

public @NotNull SelectOnStep<R>
fullJoin(Name name)

Convenience method to FULL OUTER JOIN a tableto the last table added to the FROM clause using Table#fullOuterJoin(Name).

public @NotNull SelectOnStep<R>
fullOuterJoin(TableLike<?> table)

Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table#fullOuterJoin(TableLike)

This is only possible where the underlying RDBMS supports it

public @NotNull SelectOnStep<R>
fullOuterJoin(SQL sql)

Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table#fullOuterJoin(String)

This is only possible where the underlying RDBMS supports it

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public @NotNull SelectOnStep<R>
fullOuterJoin(String sql)

Convenience method to FULL OUTER JOIN a table to the last table added to the FROM clause using Table#fullOuterJoin(String)

This is only possible where the underlying RDBMS supports it

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public @NotNull SelectOnStep<R>
fullOuterJoin(String sql, Object... bindings)

Convenience method to FULL OUTER JOIN a tableto the last table added to the FROM clause using Table#fullOuterJoin(String, Object...)

This is only possible where the underlying RDBMS supports it

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public @NotNull SelectOnStep<R>
fullOuterJoin(String sql, QueryPart... parts)

Convenience method to FULL OUTER JOIN a tableto the last table added to the FROM clause using Table#fullOuterJoin(String, QueryPart...)

This is only possible where the underlying RDBMS supports it

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public @NotNull SelectOnStep<R>
fullOuterJoin(Name name)

Convenience method to FULL OUTER JOIN a tableto the last table added to the FROM clause using Table#fullOuterJoin(Name)

This is only possible where the underlying RDBMS supports it

public @NotNull SelectOnStep<R>
innerJoin(TableLike<?> table)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table#join(TableLike).

public @NotNull SelectOnStep<R>
innerJoin(SQL sql)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table#join(String).

public @NotNull SelectOnStep<R>
innerJoin(String sql)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table#join(String).

public @NotNull SelectOnStep<R>
innerJoin(String sql, Object... bindings)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table#join(String, Object...).

public @NotNull SelectOnStep<R>
innerJoin(String sql, QueryPart... parts)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table#join(String, QueryPart...).

public @NotNull SelectOnStep<R>
innerJoin(Name name)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table#join(Name).

public @NotNull SelectOptionalOnStep<R>
join(TableLike<?> table, JoinType type)

Convenience method to join a table to the last table added to the FROM clause using Table#join(TableLike, JoinType)

Depending on the JoinType, a subsequent SelectOnStep#on(Condition) or SelectOnStep#using(Field...) clause is required.

public @NotNull SelectOnStep<R>
join(TableLike<?> table)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table#join(TableLike).

public @NotNull SelectOnStep<R>
join(SQL sql)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table#join(String).

public @NotNull SelectOnStep<R>
join(String sql)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table#join(String).

public @NotNull SelectOnStep<R>
join(String sql, Object... bindings)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table#join(String, Object...).

public @NotNull SelectOnStep<R>
join(String sql, QueryPart... parts)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table#join(String, QueryPart...).

public @NotNull SelectOnStep<R>
join(Name name)

Convenience method to INNER JOIN a table to the last table added to the FROM clause using Table#join(Name).

public @NotNull SelectOnStep<R>
leftAntiJoin(TableLike<?> table)

A synthetic LEFT ANTI JOIN clause that translates to an equivalent NOT EXISTS predicate.

public @NotNull SelectJoinPartitionByStep<R>
leftJoin(TableLike<?> table)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#leftOuterJoin(TableLike).

public @NotNull SelectJoinPartitionByStep<R>
leftJoin(SQL sql)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#leftOuterJoin(String).

public @NotNull SelectJoinPartitionByStep<R>
leftJoin(String sql)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#leftOuterJoin(String).

public @NotNull SelectJoinPartitionByStep<R>
leftJoin(String sql, Object... bindings)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#leftOuterJoin(String, Object...).

public @NotNull SelectJoinPartitionByStep<R>
leftJoin(String sql, QueryPart... parts)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#leftOuterJoin(String, QueryPart...).

public @NotNull SelectJoinPartitionByStep<R>
leftJoin(Name name)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#leftOuterJoin(Name).

public @NotNull SelectJoinPartitionByStep<R>
leftOuterJoin(TableLike<?> table)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#leftOuterJoin(TableLike)

public @NotNull SelectJoinPartitionByStep<R>
leftOuterJoin(SQL sql)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#leftOuterJoin(String)

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public @NotNull SelectJoinPartitionByStep<R>
leftOuterJoin(String sql)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#leftOuterJoin(String)

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public @NotNull SelectJoinPartitionByStep<R>
leftOuterJoin(String sql, Object... bindings)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#leftOuterJoin(String, Object...)

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public @NotNull SelectJoinPartitionByStep<R>
leftOuterJoin(String sql, QueryPart... parts)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#leftOuterJoin(String, QueryPart...)

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public @NotNull SelectJoinPartitionByStep<R>
leftOuterJoin(Name name)

Convenience method to LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#leftOuterJoin(Name)

public @NotNull SelectOnStep<R>
leftSemiJoin(TableLike<?> table)

A synthetic LEFT SEMI JOIN clause that translates to an equivalent EXISTS predicate.

public @NotNull SelectJoinStep<R>
naturalFullOuterJoin(TableLike<?> table)

Convenience method to NATURAL FULL OUTER JOIN a table to the last table added to the FROM clause using Table#naturalFullOuterJoin(TableLike)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalFullOuterJoin(SQL sql)

Convenience method to NATURAL FULL OUTER JOIN a table to the last table added to the FROM clause using Table#naturalFullOuterJoin(String)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalFullOuterJoin(String sql)

Convenience method to NATURAL FULL OUTER JOIN a table to the last table added to the FROM clause using Table#naturalFullOuterJoin(String)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalFullOuterJoin(String sql, Object... bindings)

Convenience method to NATURAL FULL OUTER JOIN a table to the last table added to the FROM clause using Table#naturalFullOuterJoin(String, Object...)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalFullOuterJoin(String sql, QueryPart... parts)

Convenience method to NATURAL FULL OUTER JOIN a table to the last table added to the FROM clause using Table#naturalFullOuterJoin(String, QueryPart...)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalFullOuterJoin(Name name)

Convenience method to NATURAL FULL OUTER JOIN a table to the last table added to the FROM clause using Table#naturalFullOuterJoin(Name)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalJoin(TableLike<?> table)

Convenience method to NATURAL JOIN a table to the last table added to the FROM clause using Table#naturalJoin(TableLike)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalJoin(SQL sql)

Convenience method to NATURAL JOIN a table to the last table added to the FROM clause using Table#naturalJoin(String)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalJoin(String sql)

Convenience method to NATURAL JOIN a table to the last table added to the FROM clause using Table#naturalJoin(String)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalJoin(String sql, Object... bindings)

Convenience method to NATURAL JOIN a table to the last table added to the FROM clause using Table#naturalJoin(String, Object...)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalJoin(String sql, QueryPart... parts)

Convenience method to NATURAL JOIN a table to the last table added to the FROM clause using Table#naturalJoin(String, QueryPart...)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalJoin(Name name)

Convenience method to NATURAL JOIN a table to the last table added to the FROM clause using Table#naturalJoin(Name)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalLeftOuterJoin(TableLike<?> table)

Convenience method to NATURAL LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#naturalLeftOuterJoin(TableLike)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalLeftOuterJoin(SQL sql)

Convenience method to NATURAL LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#naturalLeftOuterJoin(String)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalLeftOuterJoin(String sql)

Convenience method to NATURAL LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#naturalLeftOuterJoin(String)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalLeftOuterJoin(String sql, Object... bindings)

Convenience method to NATURAL LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#naturalLeftOuterJoin(String, Object...)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalLeftOuterJoin(String sql, QueryPart... parts)

Convenience method to NATURAL LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#naturalLeftOuterJoin(String, QueryPart...)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalLeftOuterJoin(Name name)

Convenience method to NATURAL LEFT OUTER JOIN a table to the last table added to the FROM clause using Table#naturalLeftOuterJoin(Name)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalRightOuterJoin(TableLike<?> table)

Convenience method to NATURAL RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#naturalRightOuterJoin(TableLike)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalRightOuterJoin(SQL sql)

Convenience method to NATURAL RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#naturalRightOuterJoin(String)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalRightOuterJoin(String sql)

Convenience method to NATURAL RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#naturalRightOuterJoin(String)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalRightOuterJoin(String sql, Object... bindings)

Convenience method to NATURAL RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#naturalRightOuterJoin(String, Object...)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalRightOuterJoin(String sql, QueryPart... parts)

Convenience method to NATURAL RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#naturalRightOuterJoin(String, QueryPart...)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
naturalRightOuterJoin(Name name)

Convenience method to NATURAL RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#naturalRightOuterJoin(Name)

Natural joins are supported by most RDBMS.

public @NotNull SelectJoinStep<R>
outerApply(TableLike<?> table)

OUTER APPLY a table to this table.

public @NotNull SelectJoinStep<R>
outerApply(SQL sql)

OUTER APPLY a table to this table.

public @NotNull SelectJoinStep<R>
outerApply(String sql)

OUTER APPLY a table to this table.

public @NotNull SelectJoinStep<R>
outerApply(String sql, Object... bindings)

OUTER APPLY a table to this table.

public @NotNull SelectJoinStep<R>
outerApply(String sql, QueryPart... parts)

OUTER APPLY a table to this table.

public @NotNull SelectJoinStep<R>
outerApply(Name name)

OUTER APPLY a table to this table.

public @NotNull SelectJoinPartitionByStep<R>
rightJoin(TableLike<?> table)

Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#rightOuterJoin(TableLike).

public @NotNull SelectJoinPartitionByStep<R>
rightJoin(SQL sql)

Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#rightOuterJoin(String).

public @NotNull SelectJoinPartitionByStep<R>
rightJoin(String sql)

Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#rightOuterJoin(String).

public @NotNull SelectJoinPartitionByStep<R>
rightJoin(String sql, Object... bindings)

Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#rightOuterJoin(String, Object...).

public @NotNull SelectJoinPartitionByStep<R>
rightJoin(String sql, QueryPart... parts)

Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#rightOuterJoin(String, QueryPart...).

public @NotNull SelectJoinPartitionByStep<R>
rightJoin(Name name)

Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#rightOuterJoin(Name).

public @NotNull SelectJoinPartitionByStep<R>
rightOuterJoin(TableLike<?> table)

Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#rightOuterJoin(TableLike)

This is only possible where the underlying RDBMS supports it

public @NotNull SelectJoinPartitionByStep<R>
rightOuterJoin(SQL sql)

Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#rightOuterJoin(String)

This is only possible where the underlying RDBMS supports it

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public @NotNull SelectJoinPartitionByStep<R>
rightOuterJoin(String sql)

Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#rightOuterJoin(String)

This is only possible where the underlying RDBMS supports it

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public @NotNull SelectJoinPartitionByStep<R>
rightOuterJoin(String sql, Object... bindings)

Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#rightOuterJoin(String, Object...)

This is only possible where the underlying RDBMS supports it

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public @NotNull SelectJoinPartitionByStep<R>
rightOuterJoin(String sql, QueryPart... parts)

Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#rightOuterJoin(String, QueryPart...)

This is only possible where the underlying RDBMS supports it

Note

When inserting plain SQL into jOOQ objects, you must guarantee syntax integrity.

public @NotNull SelectJoinPartitionByStep<R>
rightOuterJoin(Name name)

Convenience method to RIGHT OUTER JOIN a table to the last table added to the FROM clause using Table#rightOuterJoin(Name)

This is only possible where the underlying RDBMS supports it

public @NotNull SelectOnStep<R>
straightJoin(TableLike<?> table)

STRAIGHT_JOIN a table to this table.

public @NotNull SelectOnStep<R>
straightJoin(SQL sql)

STRAIGHT_JOIN a table to this table.

public @NotNull SelectOnStep<R>
straightJoin(String sql)

STRAIGHT_JOIN a table to this table.

public @NotNull SelectOnStep<R>
straightJoin(String sql, Object... bindings)

STRAIGHT_JOIN a table to this table.

public @NotNull SelectOnStep<R>
straightJoin(String sql, QueryPart... parts)

STRAIGHT_JOIN a table to this table.

public @NotNull SelectOnStep<R>
straightJoin(Name name)

STRAIGHT_JOIN a table to this table.

Inherited from org.jooq.SelectWhereStep:
wherewherewherewherewherewherewherewherewhereExistswhereNotExists