| Package | Description | 
|---|---|
| org.jooq | 
 The  
org.jooq package contains jOOQ's public API. | 
| Modifier and Type | Interface and Description | 
|---|---|
interface  | 
SelectOnConditionStep<R extends Record>
 | 
interface  | 
SelectOptionalOnStep<R extends Record>
 | 
| Modifier and Type | Method and Description | 
|---|---|
SelectJoinStep<R> | 
SelectJoinStep.crossApply(Name name)
CROSS APPLY a table to this table. | 
SelectJoinStep<R> | 
SelectJoinStep.crossApply(SQL sql)
CROSS APPLY a table to this table. | 
SelectJoinStep<R> | 
SelectJoinStep.crossApply(String sql)
CROSS APPLY a table to this table. | 
SelectJoinStep<R> | 
SelectJoinStep.crossApply(String sql,
          Object... bindings)
CROSS APPLY a table to this table. | 
SelectJoinStep<R> | 
SelectJoinStep.crossApply(String sql,
          QueryPart... parts)
CROSS APPLY a table to this table. | 
SelectJoinStep<R> | 
SelectJoinStep.crossApply(TableLike<?> table)
CROSS APPLY a table to this table. | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectJoinStep.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...) | 
SelectJoinStep<R> | 
SelectJoinStep.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...) | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectFromStep.from(Collection<? extends TableLike<?>> tables)
Add a  
FROM clause to the query. | 
SelectJoinStep<R> | 
SelectFromStep.from(Name name)
Add a  
FROM clause to the query. | 
SelectJoinStep<R> | 
SelectFromStep.from(SQL sql)
Add a  
FROM clause to the query. | 
SelectJoinStep<R> | 
SelectFromStep.from(String sql)
Add a  
FROM clause to the query. | 
SelectJoinStep<R> | 
SelectFromStep.from(String sql,
    Object... bindings)
Add a  
FROM clause to the query. | 
SelectJoinStep<R> | 
SelectFromStep.from(String sql,
    QueryPart... parts)
Add a  
FROM clause to the query. | 
SelectJoinStep<R> | 
SelectFromStep.from(TableLike<?>... tables)
Add a  
FROM clause to the query. | 
SelectJoinStep<R> | 
SelectFromStep.from(TableLike<?> table)
Add a  
FROM clause to the query. | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectJoinStep.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...) | 
SelectJoinStep<R> | 
SelectJoinStep.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...) | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectJoinStep.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...) | 
SelectJoinStep<R> | 
SelectJoinStep.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...) | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectJoinStep.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...) | 
SelectJoinStep<R> | 
SelectJoinStep.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...) | 
SelectJoinStep<R> | 
SelectJoinStep.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. | 
SelectJoinStep<R> | 
SelectOnStep.onKey()
Join the previous table on a non-ambiguous foreign key relationship
 between the two joined tables. 
 | 
SelectJoinStep<R> | 
SelectOnStep.onKey(ForeignKey<?,?> key)
Join the table on a non-ambiguous foreign key relationship between the
 two joined tables. 
 | 
SelectJoinStep<R> | 
SelectOnStep.onKey(TableField<?,?>... keyFields)
Join the previous table on a non-ambiguous foreign key relationship
 between the two joined tables. 
 | 
SelectJoinStep<R> | 
SelectJoinStep.outerApply(Name name)
OUTER APPLY a table to this table. | 
SelectJoinStep<R> | 
SelectJoinStep.outerApply(SQL sql)
OUTER APPLY a table to this table. | 
SelectJoinStep<R> | 
SelectJoinStep.outerApply(String sql)
OUTER APPLY a table to this table. | 
SelectJoinStep<R> | 
SelectJoinStep.outerApply(String sql,
          Object... bindings)
OUTER APPLY a table to this table. | 
SelectJoinStep<R> | 
SelectJoinStep.outerApply(String sql,
          QueryPart... parts)
OUTER APPLY a table to this table. | 
SelectJoinStep<R> | 
SelectJoinStep.outerApply(TableLike<?> table)
OUTER APPLY a table to this table. | 
SelectJoinStep<R> | 
SelectOnStep.using(Collection<? extends Field<?>> fields)
Join the previous table with the  
USING(column [, column...]) | 
SelectJoinStep<R> | 
SelectOnStep.using(Field<?>... fields)
Join the previous table with the  
USING(column [, column...]) | 
Copyright © 2016. All Rights Reserved.