/*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*
* Other licenses:
* -----------------------------------------------------------------------------
* Commercial licenses for this work are available. These replace the above
* ASL 2.0 and offer limited warranties, support, maintenance, and commercial
* database integrations.
*
* For more information, please visit: http://www.jooq.org/licenses
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*
*/
package org.jooq;
// ...
// ...
// ...
// ...
// ...
import static org.jooq.SQLDialect.CUBRID;
// ...
import static org.jooq.SQLDialect.DERBY;
import static org.jooq.SQLDialect.FIREBIRD;
import static org.jooq.SQLDialect.H2;
// ...
import static org.jooq.SQLDialect.HSQLDB;
// ...
// ...
import static org.jooq.SQLDialect.MARIADB;
// ...
import static org.jooq.SQLDialect.MYSQL;
// ...
// ...
import static org.jooq.SQLDialect.POSTGRES;
// ...
// ...
// ...
import static org.jooq.SQLDialect.SQLITE;
// ...
// ...
// ...
// ...
import org.jooq.impl.DSL;
import org.jetbrains.annotations.NotNull;
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:
- They're operating on mutable implementations (as of jOOQ 3.x)
- They're less composable and not easy to get right when dynamic SQL gets
complex
- They're less readable
- They might have binary incompatible changes between minor releases
Author: Lukas Eder
/**
* This type is used for the {@link Select}'s DSL API when selecting generic
* {@link Record} types.
* <p>
* Example: <code><pre>
* -- 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
* </pre></code> Its equivalent in jOOQ <code><pre>
* 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();
* </pre></code> Refer to the manual for more details
* <p>
* <h3>Referencing <code>XYZ*Step</code> types directly from client code</h3>
* <p>
* It is usually not recommended to reference any <code>XYZ*Step</code> 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: <a href=
* "https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql">https://www.jooq.org/doc/latest/manual/sql-building/dynamic-sql</a>.
* <p>
* Drawbacks of referencing the <code>XYZ*Step</code> types directly:
* <ul>
* <li>They're operating on mutable implementations (as of jOOQ 3.x)</li>
* <li>They're less composable and not easy to get right when dynamic SQL gets
* complex</li>
* <li>They're less readable</li>
* <li>They might have binary incompatible changes between minor releases</li>
* </ul>
*
* @author Lukas Eder
*/
public interface SelectJoinStep<R extends Record> extends SelectWhereStep<R> {
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. If it is required but omitted, the JOIN clause will be ignored
/**
* Convenience method to join a table to the last table added to the
* <code>FROM</code> clause using {@link Table#join(TableLike, JoinType)}
* <p>
* Depending on the <code>JoinType</code>, a subsequent
* {@link SelectOnStep#on(Condition)} or
* {@link SelectOnStep#using(Field...)} clause is required. If it is
* required but omitted, the JOIN clause will be ignored
*/
@NotNull
@Support
SelectOptionalOnStep<R> join(TableLike<?> table, JoinType type);
Convenience method to INNER JOIN
a table to the last table
added to the FROM
clause using Table.join(TableLike)
. A synonym for innerJoin(TableLike)
.
See Also:
/**
* Convenience method to <code>INNER JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using {@link Table#join(TableLike)}.
* <p>
* A synonym for {@link #innerJoin(TableLike)}.
*
* @see Table#join(TableLike)
* @see #innerJoin(TableLike)
*/
@NotNull
@Support
SelectOnStep<R> join(TableLike<?> table);
Convenience method to INNER JOIN
a table to the last table
added to the FROM
clause using Table.join(String)
. A synonym for innerJoin(String)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>INNER JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using {@link Table#join(String)}.
* <p>
* A synonym for {@link #innerJoin(String)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(SQL)
* @see Table#join(SQL)
* @see #innerJoin(SQL)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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)
. A synonym for innerJoin(String)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>INNER JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using {@link Table#join(String)}.
* <p>
* A synonym for {@link #innerJoin(String)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String)
* @see Table#join(String)
* @see #innerJoin(String)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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, Object...)
. A synonym for innerJoin(String, Object...)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>INNER JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#join(String, Object...)}.
* <p>
* A synonym for {@link #innerJoin(String, Object...)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, Object...)
* @see DSL#sql(String, Object...)
* @see Table#join(String, Object...)
* @see #innerJoin(String, Object...)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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, QueryPart...)
. A synonym for innerJoin(String, QueryPart...)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>INNER JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#join(String, QueryPart...)}.
* <p>
* A synonym for {@link #innerJoin(String, QueryPart...)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, QueryPart...)
* @see DSL#sql(String, QueryPart...)
* @see Table#join(String, QueryPart...)
* @see #innerJoin(String, QueryPart...)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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(Name)
. A synonym for innerJoin(Name)
.
See Also:
/**
* Convenience method to <code>INNER JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#join(Name)}.
* <p>
* A synonym for {@link #innerJoin(Name)}.
*
* @see DSL#table(Name)
* @see Table#join(Name)
* @see #innerJoin(Name)
*/
@NotNull
@Support
@PlainSQL
SelectOnStep<R> join(Name name);
Convenience method to INNER JOIN
a table to the last table
added to the FROM
clause using Table.join(TableLike)
. See Also:
/**
* Convenience method to <code>INNER JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using {@link Table#join(TableLike)}.
*
* @see Table#innerJoin(TableLike)
*/
@NotNull
@Support
SelectOnStep<R> innerJoin(TableLike<?> table);
Convenience method to INNER JOIN
a table to the last table
added to the FROM
clause using Table.join(String)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>INNER JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using {@link Table#join(String)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(SQL)
* @see Table#innerJoin(SQL)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>INNER JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using {@link Table#join(String)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String)
* @see Table#innerJoin(String)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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, Object...)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>INNER JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#join(String, Object...)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, Object...)
* @see DSL#sql(String, Object...)
* @see Table#innerJoin(String, Object...)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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, QueryPart...)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>INNER JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#join(String, QueryPart...)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, QueryPart...)
* @see DSL#sql(String, QueryPart...)
* @see Table#innerJoin(String, QueryPart...)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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(Name)
. See Also:
/**
* Convenience method to <code>INNER JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#join(Name)}.
*
* @see DSL#table(Name)
* @see Table#innerJoin(Name)
*/
@NotNull
@Support
SelectOnStep<R> innerJoin(Name name);
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
. The following two constructs are equivalent:
A cross join B
A join B on 1 = 1
See Also:
/**
* Convenience method to <code>CROSS JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#crossJoin(TableLike)}
* <p>
* If this syntax is unavailable, it is emulated with a regular
* <code>INNER JOIN</code>. The following two constructs are equivalent:
* <code><pre>
* A cross join B
* A join B on 1 = 1
* </pre></code>
*
* @see Table#crossJoin(TableLike)
*/
@NotNull
@Support
SelectJoinStep<R> crossJoin(TableLike<?> table);
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
. The following two constructs are equivalent:
A cross join B
A join B on 1 = 1
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>CROSS JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#crossJoin(String)}
* <p>
* If this syntax is unavailable, it is emulated with a regular
* <code>INNER JOIN</code>. The following two constructs are equivalent:
* <code><pre>
* A cross join B
* A join B on 1 = 1
* </pre></code>
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(SQL)
* @see Table#crossJoin(SQL)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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
. The following two constructs are equivalent:
A cross join B
A join B on 1 = 1
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>CROSS JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#crossJoin(String)}
* <p>
* If this syntax is unavailable, it is emulated with a regular
* <code>INNER JOIN</code>. The following two constructs are equivalent:
* <code><pre>
* A cross join B
* A join B on 1 = 1
* </pre></code>
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String)
* @see Table#crossJoin(String)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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, Object...)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN
. The following two constructs are equivalent:
A cross join B
A join B on 1 = 1
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>CROSS JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#crossJoin(String, Object...)}
* <p>
* If this syntax is unavailable, it is emulated with a regular
* <code>INNER JOIN</code>. The following two constructs are equivalent:
* <code><pre>
* A cross join B
* A join B on 1 = 1
* </pre></code>
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, Object...)
* @see DSL#sql(String, Object...)
* @see Table#crossJoin(String, Object...)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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, QueryPart...)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN
. The following two constructs are equivalent:
A cross join B
A join B on 1 = 1
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>CROSS JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#crossJoin(String, QueryPart...)}
* <p>
* If this syntax is unavailable, it is emulated with a regular
* <code>INNER JOIN</code>. The following two constructs are equivalent:
* <code><pre>
* A cross join B
* A join B on 1 = 1
* </pre></code>
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, QueryPart...)
* @see DSL#sql(String, QueryPart...)
* @see Table#crossJoin(String, QueryPart...)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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(Name)
If this syntax is unavailable, it is emulated with a regular
INNER JOIN
. The following two constructs are equivalent:
A cross join B
A join B on 1 = 1
See Also:
/**
* Convenience method to <code>CROSS JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#crossJoin(Name)}
* <p>
* If this syntax is unavailable, it is emulated with a regular
* <code>INNER JOIN</code>. The following two constructs are equivalent:
* <code><pre>
* A cross join B
* A join B on 1 = 1
* </pre></code>
*
* @see DSL#table(Name)
* @see Table#crossJoin(Name)
*/
@NotNull
@Support
SelectJoinStep<R> crossJoin(Name name);
Convenience method to LEFT OUTER JOIN
a table to the last
table added to the FROM
clause using Table.leftOuterJoin(TableLike)
. A synonym for leftOuterJoin(TableLike)
.
See Also:
/**
* Convenience method to <code>LEFT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#leftOuterJoin(TableLike)}.
* <p>
* A synonym for {@link #leftOuterJoin(TableLike)}.
*
* @see Table#leftOuterJoin(TableLike)
* @see #leftOuterJoin(TableLike)
*/
@NotNull
@Support
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(String)
. A synonym for leftOuterJoin(String)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>LEFT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#leftOuterJoin(String)}.
* <p>
* A synonym for {@link #leftOuterJoin(String)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(SQL)
* @see Table#leftOuterJoin(SQL)
* @see #leftOuterJoin(SQL)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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)
. A synonym for leftOuterJoin(String)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>LEFT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#leftOuterJoin(String)}.
* <p>
* A synonym for {@link #leftOuterJoin(String)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String)
* @see Table#leftOuterJoin(String)
* @see #leftOuterJoin(String)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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, Object...)
. A synonym for leftOuterJoin(String, Object...)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>LEFT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#leftOuterJoin(String, Object...)}.
* <p>
* A synonym for {@link #leftOuterJoin(String, Object...)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, Object...)
* @see DSL#sql(String, Object...)
* @see Table#leftOuterJoin(String, Object...)
* @see #leftOuterJoin(String, Object...)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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, QueryPart...)
. A synonym for leftOuterJoin(String, QueryPart...)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>LEFT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#leftOuterJoin(String, QueryPart...)}.
* <p>
* A synonym for {@link #leftOuterJoin(String, QueryPart...)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, QueryPart...)
* @see DSL#sql(String, QueryPart...)
* @see Table#leftOuterJoin(String, QueryPart...)
* @see #leftOuterJoin(String, QueryPart...)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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(Name)
. A synonym for leftOuterJoin(Name)
.
See Also:
/**
* Convenience method to <code>LEFT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#leftOuterJoin(Name)}.
* <p>
* A synonym for {@link #leftOuterJoin(Name)}.
*
* @see DSL#table(Name)
* @see Table#leftOuterJoin(Name)
* @see #leftOuterJoin(Name)
*/
@NotNull
@Support
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(TableLike)
See Also:
/**
* Convenience method to <code>LEFT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#leftOuterJoin(TableLike)}
*
* @see Table#leftOuterJoin(TableLike)
*/
@NotNull
@Support
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(String)
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>LEFT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#leftOuterJoin(String)}
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(SQL)
* @see Table#leftOuterJoin(SQL)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>LEFT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#leftOuterJoin(String)}
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String)
* @see Table#leftOuterJoin(String)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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, Object...)
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>LEFT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#leftOuterJoin(String, Object...)}
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, Object...)
* @see DSL#sql(String, Object...)
* @see Table#leftOuterJoin(String, Object...)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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, QueryPart...)
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>LEFT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#leftOuterJoin(String, QueryPart...)}
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, QueryPart...)
* @see DSL#sql(String, QueryPart...)
* @see Table#leftOuterJoin(String, QueryPart...)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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(Name)
See Also:
/**
* Convenience method to <code>LEFT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#leftOuterJoin(Name)}
*
* @see DSL#table(Name)
* @see Table#leftOuterJoin(Name)
*/
@NotNull
@Support
SelectJoinPartitionByStep<R> leftOuterJoin(Name name);
Convenience method to RIGHT OUTER JOIN
a table to the last
table added to the FROM
clause using Table.rightOuterJoin(TableLike)
. A synonym for rightOuterJoin(TableLike)
.
This is only possible where the underlying RDBMS supports it
See Also:
/**
* Convenience method to <code>RIGHT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#rightOuterJoin(TableLike)}.
* <p>
* A synonym for {@link #rightOuterJoin(TableLike)}.
* <p>
* This is only possible where the underlying RDBMS supports it
*
* @see Table#rightOuterJoin(TableLike)
* @see #rightOuterJoin(TableLike)
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
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(String)
. A synonym for 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. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>RIGHT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#rightOuterJoin(String)}.
* <p>
* A synonym for {@link #rightOuterJoin(String)}.
* <p>
* This is only possible where the underlying RDBMS supports it
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(SQL)
* @see Table#rightOuterJoin(SQL)
* @see #rightOuterJoin(SQL)
* @see SQL
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
@PlainSQL
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)
. A synonym for 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. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>RIGHT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#rightOuterJoin(String)}.
* <p>
* A synonym for {@link #rightOuterJoin(String)}.
* <p>
* This is only possible where the underlying RDBMS supports it
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String)
* @see Table#rightOuterJoin(String)
* @see #rightOuterJoin(String)
* @see SQL
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
@PlainSQL
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, Object...)
. A synonym for 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. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>RIGHT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#rightOuterJoin(String, Object...)}.
* <p>
* A synonym for {@link #rightOuterJoin(String, Object...)}.
* <p>
* This is only possible where the underlying RDBMS supports it
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, Object...)
* @see DSL#sql(String, Object...)
* @see Table#rightOuterJoin(String, Object...)
* @see #rightOuterJoin(String, Object...)
* @see SQL
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
@PlainSQL
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, QueryPart...)
. A synonym for 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. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>RIGHT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#rightOuterJoin(String, QueryPart...)}.
* <p>
* A synonym for {@link #rightOuterJoin(String, QueryPart...)}.
* <p>
* This is only possible where the underlying RDBMS supports it
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, QueryPart...)
* @see DSL#sql(String, QueryPart...)
* @see Table#rightOuterJoin(String, QueryPart...)
* @see #rightOuterJoin(String, QueryPart...)
* @see SQL
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
@PlainSQL
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(Name)
. A synonym for rightOuterJoin(Name)
.
This is only possible where the underlying RDBMS supports it
See Also:
/**
* Convenience method to <code>RIGHT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#rightOuterJoin(Name)}.
* <p>
* A synonym for {@link #rightOuterJoin(Name)}.
* <p>
* This is only possible where the underlying RDBMS supports it
*
* @see DSL#table(Name)
* @see Table#rightOuterJoin(Name)
* @see #rightOuterJoin(Name)
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
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(TableLike)
This is only possible where the underlying RDBMS supports it
See Also:
/**
* Convenience method to <code>RIGHT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#rightOuterJoin(TableLike)}
* <p>
* This is only possible where the underlying RDBMS supports it
*
* @see Table#rightOuterJoin(TableLike)
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
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(String)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>RIGHT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#rightOuterJoin(String)}
* <p>
* This is only possible where the underlying RDBMS supports it
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(SQL)
* @see Table#rightOuterJoin(SQL)
* @see SQL
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
@PlainSQL
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. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>RIGHT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#rightOuterJoin(String)}
* <p>
* This is only possible where the underlying RDBMS supports it
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String)
* @see Table#rightOuterJoin(String)
* @see SQL
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
@PlainSQL
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, Object...)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>RIGHT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#rightOuterJoin(String, Object...)}
* <p>
* This is only possible where the underlying RDBMS supports it
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, Object...)
* @see DSL#sql(String, Object...)
* @see Table#rightOuterJoin(String, Object...)
* @see SQL
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
@PlainSQL
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, QueryPart...)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>RIGHT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#rightOuterJoin(String, QueryPart...)}
* <p>
* This is only possible where the underlying RDBMS supports it
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, QueryPart...)
* @see DSL#sql(String, QueryPart...)
* @see Table#rightOuterJoin(String, QueryPart...)
* @see SQL
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
@PlainSQL
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(Name)
This is only possible where the underlying RDBMS supports it
See Also:
/**
* Convenience method to <code>RIGHT OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#rightOuterJoin(Name)}
* <p>
* This is only possible where the underlying RDBMS supports it
*
* @see DSL#table(Name)
* @see Table#rightOuterJoin(Name)
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
SelectJoinPartitionByStep<R> rightOuterJoin(Name name);
Convenience method to FULL OUTER JOIN
a table to the last
table added to the FROM
clause using Table.fullOuterJoin(TableLike)
. A synonym for fullOuterJoin(TableLike)
.
/**
* Convenience method to <code>FULL OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#fullOuterJoin(TableLike)}.
* <p>
* A synonym for {@link #fullOuterJoin(TableLike)}.
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
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(String)
. A synonym for fullOuterJoin(SQL)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
/**
* Convenience method to <code>FULL OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#fullOuterJoin(String)}.
* <p>
* A synonym for {@link #fullOuterJoin(SQL)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
@PlainSQL
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)
. A synonym for fullOuterJoin(String)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
/**
* Convenience method to <code>FULL OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#fullOuterJoin(String)}.
* <p>
* A synonym for {@link #fullOuterJoin(String)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
@PlainSQL
SelectOnStep<R> fullJoin(String sql);
Convenience method to FULL OUTER JOIN
a tableto the last
table added to the FROM
clause using Table.fullOuterJoin(String, Object...)
. A synonym for fullOuterJoin(String, Object...)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
/**
* Convenience method to <code>FULL OUTER JOIN</code> a tableto the last
* table added to the <code>FROM</code> clause using
* {@link Table#fullOuterJoin(String, Object...)}.
* <p>
* A synonym for {@link #fullOuterJoin(String, Object...)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
@PlainSQL
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, QueryPart...)
. A synonym for fullOuterJoin(String, QueryPart...)
.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
/**
* Convenience method to <code>FULL OUTER JOIN</code> a tableto the last
* table added to the <code>FROM</code> clause using
* {@link Table#fullOuterJoin(String, QueryPart...)}.
* <p>
* A synonym for {@link #fullOuterJoin(String, QueryPart...)}.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
@PlainSQL
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(Name)
. A synonym for fullOuterJoin(Name)
.
/**
* Convenience method to <code>FULL OUTER JOIN</code> a tableto the last
* table added to the <code>FROM</code> clause using
* {@link Table#fullOuterJoin(Name)}.
* <p>
* A synonym for {@link #fullOuterJoin(Name)}.
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
SelectOnStep<R> fullJoin(Name name);
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
See Also:
/**
* Convenience method to <code>FULL OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#fullOuterJoin(TableLike)}
* <p>
* This is only possible where the underlying RDBMS supports it
*
* @see Table#fullOuterJoin(TableLike)
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
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(String)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>FULL OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#fullOuterJoin(String)}
* <p>
* This is only possible where the underlying RDBMS supports it
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(SQL)
* @see Table#fullOuterJoin(SQL)
* @see SQL
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
@PlainSQL
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. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>FULL OUTER JOIN</code> a table to the last
* table added to the <code>FROM</code> clause using
* {@link Table#fullOuterJoin(String)}
* <p>
* This is only possible where the underlying RDBMS supports it
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String)
* @see Table#fullOuterJoin(String)
* @see SQL
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
@PlainSQL
SelectOnStep<R> fullOuterJoin(String sql);
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. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>FULL OUTER JOIN</code> a tableto the last
* table added to the <code>FROM</code> clause using
* {@link Table#fullOuterJoin(String, Object...)}
* <p>
* This is only possible where the underlying RDBMS supports it
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, Object...)
* @see DSL#sql(String, Object...)
* @see Table#fullOuterJoin(String, Object...)
* @see SQL
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
@PlainSQL
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, QueryPart...)
This is only possible where the underlying RDBMS supports it
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>FULL OUTER JOIN</code> a tableto the last
* table added to the <code>FROM</code> clause using
* {@link Table#fullOuterJoin(String, QueryPart...)}
* <p>
* This is only possible where the underlying RDBMS supports it
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, QueryPart...)
* @see DSL#sql(String, QueryPart...)
* @see Table#fullOuterJoin(String, QueryPart...)
* @see SQL
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
@PlainSQL
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(Name)
This is only possible where the underlying RDBMS supports it
See Also:
/**
* Convenience method to <code>FULL OUTER JOIN</code> a tableto the last
* table added to the <code>FROM</code> clause using
* {@link Table#fullOuterJoin(Name)}
* <p>
* This is only possible where the underlying RDBMS supports it
*
* @see DSL#table(Name)
* @see Table#fullOuterJoin(Name)
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
SelectOnStep<R> fullOuterJoin(Name name);
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. If they aren't supported, they
are emulated if jOOQ has enough information.
See Also:
/**
* Convenience method to <code>NATURAL JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#naturalJoin(TableLike)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
*
* @see Table#naturalJoin(TableLike)
*/
@NotNull
@Support
SelectJoinStep<R> naturalJoin(TableLike<?> table);
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. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#naturalJoin(String)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(SQL)
* @see Table#naturalJoin(SQL)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#naturalJoin(String)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String)
* @see Table#naturalJoin(String)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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, Object...)
Natural joins are supported by most RDBMS. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#naturalJoin(String, Object...)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, Object...)
* @see DSL#sql(String, Object...)
* @see Table#naturalJoin(String, Object...)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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, QueryPart...)
Natural joins are supported by most RDBMS. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#naturalJoin(String, QueryPart...)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, QueryPart...)
* @see DSL#sql(String, QueryPart...)
* @see Table#naturalJoin(String, QueryPart...)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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(Name)
Natural joins are supported by most RDBMS. If they aren't supported, they
are emulated if jOOQ has enough information.
See Also:
/**
* Convenience method to <code>NATURAL JOIN</code> a table to the last table
* added to the <code>FROM</code> clause using
* {@link Table#naturalJoin(Name)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
*
* @see DSL#table(Name)
* @see Table#naturalJoin(Name)
*/
@NotNull
@Support
SelectJoinStep<R> naturalJoin(Name name);
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. If they aren't supported, they
are emulated if jOOQ has enough information.
See Also:
/**
* Convenience method to <code>NATURAL LEFT OUTER JOIN</code> a table to the
* last table added to the <code>FROM</code> clause using
* {@link Table#naturalLeftOuterJoin(TableLike)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
*
* @see Table#naturalLeftOuterJoin(TableLike)
*/
@NotNull
@Support
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(String)
Natural joins are supported by most RDBMS. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL LEFT OUTER JOIN</code> a table to the
* last table added to the <code>FROM</code> clause using
* {@link Table#naturalLeftOuterJoin(String)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(SQL)
* @see Table#naturalLeftOuterJoin(SQL)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL LEFT OUTER JOIN</code> a table to the
* last table added to the <code>FROM</code> clause using
* {@link Table#naturalLeftOuterJoin(String)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String)
* @see Table#naturalLeftOuterJoin(String)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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, Object...)
Natural joins are supported by most RDBMS. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL LEFT OUTER JOIN</code> a table to the
* last table added to the <code>FROM</code> clause using
* {@link Table#naturalLeftOuterJoin(String, Object...)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, Object...)
* @see DSL#sql(String, Object...)
* @see Table#naturalLeftOuterJoin(String, Object...)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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, QueryPart...)
Natural joins are supported by most RDBMS. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL LEFT OUTER JOIN</code> a table to the
* last table added to the <code>FROM</code> clause using
* {@link Table#naturalLeftOuterJoin(String, QueryPart...)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, QueryPart...)
* @see DSL#sql(String, QueryPart...)
* @see Table#naturalLeftOuterJoin(String, QueryPart...)
* @see SQL
*/
@NotNull
@Support
@PlainSQL
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(Name)
Natural joins are supported by most RDBMS. If they aren't supported, they
are emulated if jOOQ has enough information.
See Also:
/**
* Convenience method to <code>NATURAL LEFT OUTER JOIN</code> a table to the
* last table added to the <code>FROM</code> clause using
* {@link Table#naturalLeftOuterJoin(Name)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
*
* @see DSL#table(Name)
* @see Table#naturalLeftOuterJoin(Name)
*/
@NotNull
@Support
SelectJoinStep<R> naturalLeftOuterJoin(Name name);
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. If they aren't supported, they
are emulated if jOOQ has enough information.
See Also:
/**
* Convenience method to <code>NATURAL RIGHT OUTER JOIN</code> a table to
* the last table added to the <code>FROM</code> clause using
* {@link Table#naturalRightOuterJoin(TableLike)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
*
* @see Table#naturalRightOuterJoin(TableLike)
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
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(String)
Natural joins are supported by most RDBMS. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL RIGHT OUTER JOIN</code> a table to
* the last table added to the <code>FROM</code> clause using
* {@link Table#naturalRightOuterJoin(String)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(SQL)
* @see Table#naturalRightOuterJoin(SQL)
* @see SQL
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
@PlainSQL
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. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL RIGHT OUTER JOIN</code> a table to
* the last table added to the <code>FROM</code> clause using
* {@link Table#naturalRightOuterJoin(String)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String)
* @see Table#naturalRightOuterJoin(String)
* @see SQL
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
@PlainSQL
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, Object...)
Natural joins are supported by most RDBMS. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL RIGHT OUTER JOIN</code> a table to
* the last table added to the <code>FROM</code> clause using
* {@link Table#naturalRightOuterJoin(String, Object...)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, Object...)
* @see DSL#sql(String, Object...)
* @see Table#naturalRightOuterJoin(String, Object...)
* @see SQL
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
@PlainSQL
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, QueryPart...)
Natural joins are supported by most RDBMS. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL RIGHT OUTER JOIN</code> a table to
* the last table added to the <code>FROM</code> clause using
* {@link Table#naturalRightOuterJoin(String, QueryPart...)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, QueryPart...)
* @see DSL#sql(String, QueryPart...)
* @see Table#naturalRightOuterJoin(String, QueryPart...)
* @see SQL
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
@PlainSQL
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(Name)
Natural joins are supported by most RDBMS. If they aren't supported, they
are emulated if jOOQ has enough information.
See Also:
/**
* Convenience method to <code>NATURAL RIGHT OUTER JOIN</code> a table to
* the last table added to the <code>FROM</code> clause using
* {@link Table#naturalRightOuterJoin(Name)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
*
* @see DSL#table(Name)
* @see Table#naturalRightOuterJoin(Name)
*/
@NotNull
@Support({ CUBRID, DERBY, FIREBIRD, H2, HSQLDB, MARIADB, MYSQL, POSTGRES })
SelectJoinStep<R> naturalRightOuterJoin(Name name);
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. If they aren't supported, they
are emulated if jOOQ has enough information.
See Also:
/**
* Convenience method to <code>NATURAL FULL OUTER JOIN</code> a table to
* the last table added to the <code>FROM</code> clause using
* {@link Table#naturalFullOuterJoin(TableLike)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
*
* @see Table#naturalFullOuterJoin(TableLike)
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
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(String)
Natural joins are supported by most RDBMS. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL FULL OUTER JOIN</code> a table to
* the last table added to the <code>FROM</code> clause using
* {@link Table#naturalFullOuterJoin(String)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(SQL)
* @see Table#naturalFullOuterJoin(SQL)
* @see SQL
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
@PlainSQL
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. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL FULL OUTER JOIN</code> a table to
* the last table added to the <code>FROM</code> clause using
* {@link Table#naturalFullOuterJoin(String)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String)
* @see Table#naturalFullOuterJoin(String)
* @see SQL
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
@PlainSQL
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, Object...)
Natural joins are supported by most RDBMS. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL FULL OUTER JOIN</code> a table to
* the last table added to the <code>FROM</code> clause using
* {@link Table#naturalFullOuterJoin(String, Object...)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, Object...)
* @see DSL#sql(String, Object...)
* @see Table#naturalFullOuterJoin(String, Object...)
* @see SQL
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
@PlainSQL
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, QueryPart...)
Natural joins are supported by most RDBMS. If they aren't supported, they
are emulated if jOOQ has enough information.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also:
/**
* Convenience method to <code>NATURAL FULL OUTER JOIN</code> a table to
* the last table added to the <code>FROM</code> clause using
* {@link Table#naturalFullOuterJoin(String, QueryPart...)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, QueryPart...)
* @see DSL#sql(String, QueryPart...)
* @see Table#naturalFullOuterJoin(String, QueryPart...)
* @see SQL
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
@PlainSQL
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(Name)
Natural joins are supported by most RDBMS. If they aren't supported, they
are emulated if jOOQ has enough information.
See Also:
/**
* Convenience method to <code>NATURAL FULL OUTER JOIN</code> a table to
* the last table added to the <code>FROM</code> clause using
* {@link Table#naturalFullOuterJoin(Name)}
* <p>
* Natural joins are supported by most RDBMS. If they aren't supported, they
* are emulated if jOOQ has enough information.
*
* @see DSL#table(Name)
* @see Table#naturalFullOuterJoin(Name)
*/
@NotNull
@Support({ FIREBIRD, HSQLDB, POSTGRES })
SelectJoinStep<R> naturalFullOuterJoin(Name name);
// -------------------------------------------------------------------------
// XXX: SEMI and ANTI JOIN
// -------------------------------------------------------------------------
A synthetic LEFT SEMI JOIN
clause that translates to an
equivalent EXISTS
predicate.
The following two SQL snippets are semantically equivalent:
-- Using LEFT SEMI JOIN
FROM A
LEFT SEMI JOIN B
ON A.ID = B.ID
-- Using WHERE EXISTS
FROM A
WHERE EXISTS (
SELECT 1 FROM B WHERE A.ID = B.ID
)
Notice that according to
Relational
algebra's understanding of left semi join, the right hand side of the
left semi join operator is not projected, i.e. it cannot be accessed from
WHERE
or SELECT
or any other clause than
ON
.
See Also: - leftSemiJoin.leftSemiJoin(TableLike)
/**
* A synthetic <code>LEFT SEMI JOIN</code> clause that translates to an
* equivalent <code>EXISTS</code> predicate.
* <p>
* The following two SQL snippets are semantically equivalent:
* <code><pre>
* -- Using LEFT SEMI JOIN
* FROM A
* LEFT SEMI JOIN B
* ON A.ID = B.ID
*
* -- Using WHERE EXISTS
* FROM A
* WHERE EXISTS (
* SELECT 1 FROM B WHERE A.ID = B.ID
* )
* </pre></code>
* <p>
* Notice that according to
* <a href="https://en.wikipedia.org/wiki/Relational_algebra">Relational
* algebra's</a> understanding of left semi join, the right hand side of the
* left semi join operator is not projected, i.e. it cannot be accessed from
* <code>WHERE</code> or <code>SELECT</code> or any other clause than
* <code>ON</code>.
*
* @see Table#leftSemiJoin(TableLike)
*/
@NotNull
@Support
SelectOnStep<R> leftSemiJoin(TableLike<?> table);
A synthetic LEFT ANTI JOIN
clause that translates to an
equivalent NOT EXISTS
predicate.
The following two SQL snippets are semantically equivalent:
-- Using LEFT ANTI JOIN
FROM A
LEFT ANTI JOIN B
ON A.ID = B.ID
-- Using WHERE NOT EXISTS
FROM A
WHERE NOT EXISTS (
SELECT 1 FROM B WHERE A.ID = B.ID
)
Notice that according to
Relational
algebra's understanding of left semi join, the right hand side of the
left semi join operator is not projected, i.e. it cannot be accessed from
WHERE
or SELECT
or any other clause than
ON
.
See Also: - leftAntiJoin.leftAntiJoin(TableLike)
/**
* A synthetic <code>LEFT ANTI JOIN</code> clause that translates to an
* equivalent <code>NOT EXISTS</code> predicate.
* <p>
* The following two SQL snippets are semantically equivalent:
* <code><pre>
* -- Using LEFT ANTI JOIN
* FROM A
* LEFT ANTI JOIN B
* ON A.ID = B.ID
*
* -- Using WHERE NOT EXISTS
* FROM A
* WHERE NOT EXISTS (
* SELECT 1 FROM B WHERE A.ID = B.ID
* )
* </pre></code>
* <p>
* Notice that according to
* <a href="https://en.wikipedia.org/wiki/Relational_algebra">Relational
* algebra's</a> understanding of left semi join, the right hand side of the
* left semi join operator is not projected, i.e. it cannot be accessed from
* <code>WHERE</code> or <code>SELECT</code> or any other clause than
* <code>ON</code>.
*
* @see Table#leftAntiJoin(TableLike)
*/
@NotNull
@Support
SelectOnStep<R> leftAntiJoin(TableLike<?> table);
// -------------------------------------------------------------------------
// XXX: APPLY clauses on tables
// -------------------------------------------------------------------------
CROSS APPLY
a table to this table.
See Also: - crossApply.crossApply(TableLike)
/**
* <code>CROSS APPLY</code> a table to this table.
*
* @see Table#crossApply(TableLike)
*/
@NotNull
@Support({ POSTGRES })
SelectJoinStep<R> crossApply(TableLike<?> table);
CROSS APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also: - table.table(SQL)
- Table.crossApply(SQL)
- SQL
/**
* <code>CROSS APPLY</code> a table to this table.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(SQL)
* @see Table#crossApply(SQL)
* @see SQL
*/
@NotNull
@Support({ POSTGRES })
@PlainSQL
SelectJoinStep<R> crossApply(SQL sql);
CROSS APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also: - table.table(String)
- Table.crossApply(String)
- SQL
/**
* <code>CROSS APPLY</code> a table to this table.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String)
* @see Table#crossApply(String)
* @see SQL
*/
@NotNull
@Support({ POSTGRES })
@PlainSQL
SelectJoinStep<R> crossApply(String sql);
CROSS APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also: - table.table(String, Object...)
- DSL.sql(String, Object...)
- Table.crossApply(String, Object...)
- SQL
/**
* <code>CROSS APPLY</code> a table to this table.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, Object...)
* @see DSL#sql(String, Object...)
* @see Table#crossApply(String, Object...)
* @see SQL
*/
@NotNull
@Support({ POSTGRES })
@PlainSQL
SelectJoinStep<R> crossApply(String sql, Object... bindings);
CROSS APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also: - table.table(String, QueryPart...)
- DSL.sql(String, QueryPart...)
- Table.crossApply(String, QueryPart...)
- SQL
/**
* <code>CROSS APPLY</code> a table to this table.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, QueryPart...)
* @see DSL#sql(String, QueryPart...)
* @see Table#crossApply(String, QueryPart...)
* @see SQL
*/
@NotNull
@Support({ POSTGRES })
@PlainSQL
SelectJoinStep<R> crossApply(String sql, QueryPart... parts);
CROSS APPLY
a table to this table.
See Also: - table.table(Name)
- Table.crossApply(Name)
/**
* <code>CROSS APPLY</code> a table to this table.
*
* @see DSL#table(Name)
* @see Table#crossApply(Name)
*/
@NotNull
@Support({ POSTGRES })
SelectJoinStep<R> crossApply(Name name);
OUTER APPLY
a table to this table.
See Also: - outerApply.outerApply(TableLike)
/**
* <code>OUTER APPLY</code> a table to this table.
*
* @see Table#outerApply(TableLike)
*/
@NotNull
@Support({ POSTGRES })
SelectJoinStep<R> outerApply(TableLike<?> table);
OUTER APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also: - table.table(SQL)
- Table.outerApply(SQL)
- SQL
/**
* <code>OUTER APPLY</code> a table to this table.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(SQL)
* @see Table#outerApply(SQL)
* @see SQL
*/
@NotNull
@Support({ POSTGRES })
@PlainSQL
SelectJoinStep<R> outerApply(SQL sql);
OUTER APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also: - table.table(String)
- Table.outerApply(String)
- SQL
/**
* <code>OUTER APPLY</code> a table to this table.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String)
* @see Table#outerApply(String)
* @see SQL
*/
@NotNull
@Support({ POSTGRES })
@PlainSQL
SelectJoinStep<R> outerApply(String sql);
OUTER APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also: - table.table(String, Object...)
- DSL.sql(String, Object...)
- Table.outerApply(String, Object...)
- SQL
/**
* <code>OUTER APPLY</code> a table to this table.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, Object...)
* @see DSL#sql(String, Object...)
* @see Table#outerApply(String, Object...)
* @see SQL
*/
@NotNull
@Support({ POSTGRES })
@PlainSQL
SelectJoinStep<R> outerApply(String sql, Object... bindings);
OUTER APPLY
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also: - table.table(String, QueryPart...)
- DSL.sql(String, QueryPart...)
- Table.outerApply(String, QueryPart...)
- SQL
/**
* <code>OUTER APPLY</code> a table to this table.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, QueryPart...)
* @see DSL#sql(String, QueryPart...)
* @see Table#outerApply(String, QueryPart...)
* @see SQL
*/
@NotNull
@Support({ POSTGRES })
@PlainSQL
SelectJoinStep<R> outerApply(String sql, QueryPart... parts);
OUTER APPLY
a table to this table.
See Also: - table.table(Name)
- Table.outerApply(Name)
/**
* <code>OUTER APPLY</code> a table to this table.
*
* @see DSL#table(Name)
* @see Table#outerApply(Name)
*/
@NotNull
@Support({ POSTGRES })
SelectJoinStep<R> outerApply(Name name);
STRAIGHT_JOIN
a table to this table.
See Also: - straightJoin.straightJoin(TableLike)
/**
* <code>STRAIGHT_JOIN</code> a table to this table.
*
* @see Table#straightJoin(TableLike)
*/
@NotNull
@Support({ MYSQL })
SelectOnStep<R> straightJoin(TableLike<?> table);
STRAIGHT_JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also: - table.table(SQL)
- Table.straightJoin(SQL)
/**
* <code>STRAIGHT_JOIN</code> a table to this table.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(SQL)
* @see Table#straightJoin(SQL)
*/
@NotNull
@Support({ MYSQL })
@PlainSQL
SelectOnStep<R> straightJoin(SQL sql);
STRAIGHT_JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also: - table.table(String)
- Table.straightJoin(String)
/**
* <code>STRAIGHT_JOIN</code> a table to this table.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String)
* @see Table#straightJoin(String)
*/
@NotNull
@Support({ MYSQL })
@PlainSQL
SelectOnStep<R> straightJoin(String sql);
STRAIGHT_JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also: - table.table(String, Object...)
- DSL.sql(String, Object...)
- Table.straightJoin(String, Object...)
/**
* <code>STRAIGHT_JOIN</code> a table to this table.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, Object...)
* @see DSL#sql(String, Object...)
* @see Table#straightJoin(String, Object...)
*/
@NotNull
@Support({ MYSQL })
@PlainSQL
SelectOnStep<R> straightJoin(String sql, Object... bindings);
STRAIGHT_JOIN
a table to this table.
NOTE: When inserting plain SQL into jOOQ objects, you must
guarantee syntax integrity. You may also create the possibility of
malicious SQL injection. Be sure to properly use bind variables and/or
escape literals when concatenated into SQL clauses!
See Also: - table.table(String, QueryPart...)
- DSL.sql(String, QueryPart...)
- Table.straightJoin(String, QueryPart...)
/**
* <code>STRAIGHT_JOIN</code> a table to this table.
* <p>
* <b>NOTE</b>: When inserting plain SQL into jOOQ objects, you must
* guarantee syntax integrity. You may also create the possibility of
* malicious SQL injection. Be sure to properly use bind variables and/or
* escape literals when concatenated into SQL clauses!
*
* @see DSL#table(String, QueryPart...)
* @see DSL#sql(String, QueryPart...)
* @see Table#straightJoin(String, QueryPart...)
*/
@NotNull
@Support({ MYSQL })
@PlainSQL
SelectOnStep<R> straightJoin(String sql, QueryPart... parts);
STRAIGHT_JOIN
a table to this table.
See Also: - table.table(Name)
- Table.straightJoin(Name)
/**
* <code>STRAIGHT_JOIN</code> a table to this table.
*
* @see DSL#table(Name)
* @see Table#straightJoin(Name)
*/
@NotNull
@Support({ MYSQL })
SelectOnStep<R> straightJoin(Name name);
}