public interface TableOnConditionStep<R extends Record> extends Table<R>
JOIN
clause, where the join criteria is added using an ON
clause
(with a Condition
. This type can be used as a convenience type for
connecting more conditions.Modifier and Type | Method and Description |
---|---|
TableOnConditionStep<R> |
and(java.lang.Boolean condition)
Deprecated.
- 3.8.0 - [#4763] - Use
and(Condition) or
and(Field) instead. Due to ambiguity between
calling this method using Field.equals(Object)
argument, vs. calling the other method via a
Field.equal(Object) argument, this method will be
removed in the future. |
TableOnConditionStep<R> |
and(Condition condition)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
TableOnConditionStep<R> |
and(Field<java.lang.Boolean> condition)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
TableOnConditionStep<R> |
and(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
TableOnConditionStep<R> |
and(java.lang.String sql)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
TableOnConditionStep<R> |
and(java.lang.String sql,
java.lang.Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
TableOnConditionStep<R> |
and(java.lang.String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.AND operator. |
TableOnConditionStep<R> |
andExists(Select<?> select)
Combine the currently assembled conditions with an
EXISTS
clause using the Operator.AND operator. |
TableOnConditionStep<R> |
andNot(java.lang.Boolean condition)
Deprecated.
- 3.8.0 - [#4763] - Use
andNot(Condition) or
andNot(Field) instead. Due to ambiguity between
calling this method using Field.equals(Object)
argument, vs. calling the other method via a
Field.equal(Object) argument, this method will be
removed in the future. |
TableOnConditionStep<R> |
andNot(Condition condition)
Combine the currently assembled conditions with a negated other one using
the
Operator.AND operator. |
TableOnConditionStep<R> |
andNot(Field<java.lang.Boolean> condition)
Combine the currently assembled conditions with a negated other one using
the
Operator.AND operator. |
TableOnConditionStep<R> |
andNotExists(Select<?> select)
Combine the currently assembled conditions with a
NOT EXISTS
clause using the Operator.AND operator. |
TableOnConditionStep<R> |
or(java.lang.Boolean condition)
Deprecated.
- 3.8.0 - [#4763] - Use
or(Condition) or
or(Field) instead. Due to ambiguity between
calling this method using Field.equals(Object)
argument, vs. calling the other method via a
Field.equal(Object) argument, this method will be
removed in the future. |
TableOnConditionStep<R> |
or(Condition condition)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
TableOnConditionStep<R> |
or(Field<java.lang.Boolean> condition)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
TableOnConditionStep<R> |
or(SQL sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
TableOnConditionStep<R> |
or(java.lang.String sql)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
TableOnConditionStep<R> |
or(java.lang.String sql,
java.lang.Object... bindings)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
TableOnConditionStep<R> |
or(java.lang.String sql,
QueryPart... parts)
Combine the currently assembled conditions with another one using the
Operator.OR operator. |
TableOnConditionStep<R> |
orExists(Select<?> select)
Combine the currently assembled conditions with an
EXISTS
clause using the Operator.OR operator. |
TableOnConditionStep<R> |
orNot(java.lang.Boolean condition)
Deprecated.
- 3.8.0 - [#4763] - Use
orNot(Condition) or
orNot(Field) instead. Due to ambiguity between
calling this method using Field.equals(Object)
argument, vs. calling the other method via a
Field.equal(Object) argument, this method will be
removed in the future. |
TableOnConditionStep<R> |
orNot(Condition condition)
Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator. |
TableOnConditionStep<R> |
orNot(Field<java.lang.Boolean> condition)
Combine the currently assembled conditions with a negated other one using
the
Operator.OR operator. |
TableOnConditionStep<R> |
orNotExists(Select<?> select)
Combine the currently assembled conditions with a
NOT EXISTS
clause using the Operator.OR operator. |
as, as, as, as, as, as, as, as, as, as, as, as, asOfScn, asOfScn, asOfTimestamp, asOfTimestamp, at, at, at, crossApply, crossApply, crossApply, crossApply, crossApply, crossApply, crossJoin, crossJoin, crossJoin, crossJoin, crossJoin, crossJoin, divideBy, eq, equal, equals, forceIndex, forceIndexForGroupBy, forceIndexForJoin, forceIndexForOrderBy, from, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, fullOuterJoin, getCatalog, getComment, getDataType, getIdentity, getIndexes, getKeys, getName, getPrimaryKey, getQualifiedName, getRecordTimestamp, getRecordType, getRecordVersion, getReferences, getReferencesFrom, getReferencesTo, getSchema, getUnqualifiedName, ignoreIndex, ignoreIndexForGroupBy, ignoreIndexForJoin, ignoreIndexForOrderBy, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, innerJoin, join, join, join, join, join, join, join, leftAntiJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftOuterJoin, leftSemiJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalLeftOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, naturalRightOuterJoin, ne, newRecord, notEqual, outerApply, outerApply, outerApply, outerApply, outerApply, outerApply, partitionBy, partitionBy, pivot, pivot, recordType, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, rightOuterJoin, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, straightJoin, useIndex, useIndexForGroupBy, useIndexForJoin, useIndexForOrderBy, versionsBetweenScn, versionsBetweenScn, versionsBetweenScnMinvalue, versionsBetweenTimestamp, versionsBetweenTimestamp, versionsBetweenTimestampMinvalue, with
@Support TableOnConditionStep<R> and(Condition condition)
Operator.AND
operator.@Support TableOnConditionStep<R> and(Field<java.lang.Boolean> condition)
Operator.AND
operator.@Deprecated @Support TableOnConditionStep<R> and(java.lang.Boolean condition)
and(Condition)
or
and(Field)
instead. Due to ambiguity between
calling this method using Field.equals(Object)
argument, vs. calling the other method via a
Field.equal(Object)
argument, this method will be
removed in the future.Operator.AND
operator.@Support @PlainSQL TableOnConditionStep<R> and(SQL sql)
Operator.AND
operator.
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!
DSL.condition(SQL)
,
SQL
@Support @PlainSQL TableOnConditionStep<R> and(java.lang.String sql)
Operator.AND
operator.
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!
DSL.condition(String)
,
SQL
@Support @PlainSQL TableOnConditionStep<R> and(java.lang.String sql, java.lang.Object... bindings)
Operator.AND
operator.
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!
@Support @PlainSQL TableOnConditionStep<R> and(java.lang.String sql, QueryPart... parts)
Operator.AND
operator.
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!
@Support TableOnConditionStep<R> andNot(Condition condition)
Operator.AND
operator.@Support TableOnConditionStep<R> andNot(Field<java.lang.Boolean> condition)
Operator.AND
operator.@Deprecated @Support TableOnConditionStep<R> andNot(java.lang.Boolean condition)
andNot(Condition)
or
andNot(Field)
instead. Due to ambiguity between
calling this method using Field.equals(Object)
argument, vs. calling the other method via a
Field.equal(Object)
argument, this method will be
removed in the future.Operator.AND
operator.@Support TableOnConditionStep<R> andExists(Select<?> select)
EXISTS
clause using the Operator.AND
operator.@Support TableOnConditionStep<R> andNotExists(Select<?> select)
NOT EXISTS
clause using the Operator.AND
operator.@Support TableOnConditionStep<R> or(Condition condition)
Operator.OR
operator.@Support TableOnConditionStep<R> or(Field<java.lang.Boolean> condition)
Operator.OR
operator.@Deprecated @Support TableOnConditionStep<R> or(java.lang.Boolean condition)
or(Condition)
or
or(Field)
instead. Due to ambiguity between
calling this method using Field.equals(Object)
argument, vs. calling the other method via a
Field.equal(Object)
argument, this method will be
removed in the future.Operator.OR
operator.@Support @PlainSQL TableOnConditionStep<R> or(SQL sql)
Operator.OR
operator.
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!
DSL.condition(SQL)
,
SQL
@Support @PlainSQL TableOnConditionStep<R> or(java.lang.String sql)
Operator.OR
operator.
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!
DSL.condition(String)
,
SQL
@Support @PlainSQL TableOnConditionStep<R> or(java.lang.String sql, java.lang.Object... bindings)
Operator.OR
operator.
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!
@Support @PlainSQL TableOnConditionStep<R> or(java.lang.String sql, QueryPart... parts)
Operator.OR
operator.
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!
@Support TableOnConditionStep<R> orNot(Condition condition)
Operator.OR
operator.@Support TableOnConditionStep<R> orNot(Field<java.lang.Boolean> condition)
Operator.OR
operator.@Deprecated @Support TableOnConditionStep<R> orNot(java.lang.Boolean condition)
orNot(Condition)
or
orNot(Field)
instead. Due to ambiguity between
calling this method using Field.equals(Object)
argument, vs. calling the other method via a
Field.equal(Object)
argument, this method will be
removed in the future.Operator.OR
operator.@Support TableOnConditionStep<R> orExists(Select<?> select)
EXISTS
clause using the Operator.OR
operator.@Support TableOnConditionStep<R> orNotExists(Select<?> select)
NOT EXISTS
clause using the Operator.OR
operator.Copyright © 2018. All Rights Reserved.