org.jooq

Interface TableOuterJoinStep<R extends Record>

public interface TableOuterJoinStep<R extends Record>

An intermediate type for the construction of a partitioned SQLDialect.ORACLE OUTER JOIN clause.

This step allows for adding Oracle-specific PARTITION BY clauses to the left of an OUTER JOIN keyword. See the Oracle documentation for more details here: https://docs.oracle.com/database/121/SQLRF/statements_10002.htm#BABBCHJA

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

Method Summary

Modifier and Type	Method and Description
TableOnStep<Record>	join(TableLike<?> table, JoinType type) Join a table to this table using a JoinType.
TableOnStep<Record>	leftJoin(Name name) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftJoin(SQL sql) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftJoin(String sql) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftJoin(String sql, Object... bindings) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftJoin(String sql, QueryPart... parts) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftJoin(TableLike<?> table) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftOuterJoin(Name name) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftOuterJoin(SQL sql) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftOuterJoin(String sql) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftOuterJoin(String sql, Object... bindings) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftOuterJoin(String sql, QueryPart... parts) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	leftOuterJoin(TableLike<?> table) LEFT OUTER JOIN a table to this table.
TableOnStep<Record>	rightJoin(Name name) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightJoin(SQL sql) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightJoin(String sql) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightJoin(String sql, Object... bindings) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightJoin(String sql, QueryPart... parts) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightJoin(TableLike<?> table) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightOuterJoin(Name name) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightOuterJoin(SQL sql) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightOuterJoin(String sql) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightOuterJoin(String sql, Object... bindings) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightOuterJoin(String sql, QueryPart... parts) RIGHT OUTER JOIN a table to this table.
TableOnStep<Record>	rightOuterJoin(TableLike<?> table) RIGHT OUTER JOIN a table to this table.

Method Detail

join

@Support
TableOnStep<Record> join(TableLike<?> table,
                                   JoinType type)

Join a table to this table using a JoinType.

Only JoinType.LEFT_OUTER_JOIN, JoinType.RIGHT_OUTER_JOIN, and JoinType.FULL_OUTER_JOIN are allowed.

leftJoin

@Support
TableOnStep<Record> leftJoin(TableLike<?> table)

LEFT OUTER JOIN a table to this table.

A synonym for leftOuterJoin(TableLike).

See Also:

leftOuterJoin(TableLike)

leftJoin

@Support
 @PlainSQL
TableOnStep<Record> leftJoin(SQL sql)

LEFT OUTER JOIN a table to this table.

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:

DSL.table(SQL), leftOuterJoin(SQL), SQL

leftJoin

@Support
 @PlainSQL
TableOnStep<Record> leftJoin(String sql)

LEFT OUTER JOIN a table to this table.

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:

DSL.table(String), leftOuterJoin(String), SQL

leftJoin

@Support
 @PlainSQL
TableOnStep<Record> leftJoin(String sql,
                                                   Object... bindings)

LEFT OUTER JOIN a table to this table.

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:

DSL.table(String, Object...), DSL.sql(String, Object...), leftOuterJoin(String, Object...), SQL

leftJoin

@Support
 @PlainSQL
TableOnStep<Record> leftJoin(String sql,
                                                   QueryPart... parts)

LEFT OUTER JOIN a table to this table.

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:

DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), leftOuterJoin(String, QueryPart...), SQL

leftJoin

@Support
TableOnStep<Record> leftJoin(Name name)

LEFT OUTER JOIN a table to this table.

A synonym for leftOuterJoin(Name).

See Also:

DSL.table(Name), leftOuterJoin(Name)

leftOuterJoin

@Support
TableOnStep<Record> leftOuterJoin(TableLike<?> table)

LEFT OUTER JOIN a table to this table.

leftOuterJoin

@Support
 @PlainSQL
TableOnStep<Record> leftOuterJoin(SQL sql)

LEFT OUTER 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:

DSL.table(SQL), SQL

leftOuterJoin

@Support
 @PlainSQL
TableOnStep<Record> leftOuterJoin(String sql)

LEFT OUTER 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:

DSL.table(String), SQL

leftOuterJoin

@Support
 @PlainSQL
TableOnStep<Record> leftOuterJoin(String sql,
                                                        Object... bindings)

LEFT OUTER 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:

DSL.table(String, Object...), DSL.sql(String, Object...), SQL

leftOuterJoin

@Support
 @PlainSQL
TableOnStep<Record> leftOuterJoin(String sql,
                                                        QueryPart... parts)

LEFT OUTER 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:

DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL

leftOuterJoin

@Support
TableOnStep<Record> leftOuterJoin(Name name)

LEFT OUTER JOIN a table to this table.

See Also:

DSL.table(Name), SQL

rightJoin

@Support(value={ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
TableOnStep<Record> rightJoin(TableLike<?> table)

RIGHT OUTER JOIN a table to this table.

A synonym for rightOuterJoin(TableLike).

This is only possible where the underlying RDBMS supports it.

See Also:

rightOuterJoin(TableLike)

rightJoin

@Support(value={ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
 @PlainSQL
TableOnStep<Record> rightJoin(SQL sql)

RIGHT OUTER JOIN a table to this table.

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:

DSL.table(SQL), rightOuterJoin(SQL), SQL

rightJoin

@Support(value={ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
 @PlainSQL
TableOnStep<Record> rightJoin(String sql)

RIGHT OUTER JOIN a table to this table.

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:

DSL.table(String), rightOuterJoin(String), SQL

rightJoin

@Support(value={ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
 @PlainSQL
TableOnStep<Record> rightJoin(String sql,
                                                                                                                                                                                                                                               Object... bindings)

RIGHT OUTER JOIN a table to this table.

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:

DSL.table(String, Object...), DSL.sql(String, Object...), rightOuterJoin(String, Object...), SQL

rightJoin

@Support(value={ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
 @PlainSQL
TableOnStep<Record> rightJoin(String sql,
                                                                                                                                                                                                                                               QueryPart... parts)

RIGHT OUTER JOIN a table to this table.

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:

DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), rightOuterJoin(String, QueryPart...), SQL

rightJoin

@Support(value={ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
TableOnStep<Record> rightJoin(Name name)

RIGHT OUTER JOIN a table to this table.

A synonym for rightOuterJoin(Name).

This is only possible where the underlying RDBMS supports it

See Also:

DSL.table(Name), rightOuterJoin(Name)

rightOuterJoin

@Support(value={ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
TableOnStep<Record> rightOuterJoin(TableLike<?> table)

RIGHT OUTER JOIN a table to this table.

This is only possible where the underlying RDBMS supports it

rightOuterJoin

@Support(value={ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
 @PlainSQL
TableOnStep<Record> rightOuterJoin(SQL sql)

RIGHT OUTER JOIN a table to this table.

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:

DSL.table(SQL), SQL

rightOuterJoin

@Support(value={ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
 @PlainSQL
TableOnStep<Record> rightOuterJoin(String sql)

RIGHT OUTER JOIN a table to this table.

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:

DSL.table(String), SQL

rightOuterJoin

@Support(value={ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
 @PlainSQL
TableOnStep<Record> rightOuterJoin(String sql,
                                                                                                                                                                                                                                                    Object... bindings)

RIGHT OUTER JOIN a table to this table.

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:

DSL.table(String, Object...), DSL.sql(String, Object...), SQL

rightOuterJoin

@Support(value={ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
 @PlainSQL
TableOnStep<Record> rightOuterJoin(String sql,
                                                                                                                                                                                                                                                    QueryPart... parts)

RIGHT OUTER JOIN a table to this table.

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:

DSL.table(String, QueryPart...), DSL.sql(String, QueryPart...), SQL

rightOuterJoin

@Support(value={ACCESS,ASE,AURORA_MYSQL,AURORA_POSTGRES,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,MARIADB,MYSQL,ORACLE,POSTGRES,SQLDATAWAREHOUSE,SQLSERVER,SYBASE,TERADATA,VERTICA})
TableOnStep<Record> rightOuterJoin(Name name)

RIGHT OUTER JOIN a table to this table.

This is only possible where the underlying RDBMS supports it

See Also:

DSL.table(Name)