org.jooq
Interface SelectJoinStep

All Superinterfaces:

Adapter, Attachable, FieldLike, FieldProvider, Query, QueryPart, Select<Record>, SelectFinalStep, SelectGroupByStep, SelectHavingStep, SelectLimitStep, SelectOrderByStep, SelectWhereStep, Serializable, TableLike<Record>

All Known Subinterfaces:

SelectFromStep, SelectOnConditionStep, SelectSelectStep

public interface SelectJoinStep
extends SelectWhereStep

The join step in a Select query

This is the step in query construction, where you can join tables to a query. This step is optional. If you join tables, you must proceed to the SelectOnStep. Or you can skip that and proceed directly to the SelectWhereStep

Author:

Lukas Eder

Method Summary

SelectJoinStep	crossJoin(String sql) CROSS JOIN a table and proceed to the next step
SelectJoinStep	crossJoin(String sql, Object... bindings) CROSS JOIN a table and proceed to the next step
SelectJoinStep	crossJoin(TableLike<?> table) CROSS JOIN a table and proceed to the next step
SelectOnStep	fullOuterJoin(String sql) FULL OUTER JOIN a table and proceed to the next step This is only possible where the underlying RDBMS supports it
SelectOnStep	fullOuterJoin(String sql, Object... bindings) FULL OUTER JOIN a table and proceed to the next step This is only possible where the underlying RDBMS supports it
SelectOnStep	fullOuterJoin(TableLike<?> table) FULL OUTER JOIN a table and proceed to the next step This is only possible where the underlying RDBMS supports it
SelectOnStep	join(String sql) INNER JOIN a table and proceed to the next step
SelectOnStep	join(String sql, Object... bindings) INNER JOIN a table and proceed to the next step
SelectOnStep	join(TableLike<?> table) INNER JOIN a table and proceed to the next step
SelectOnStep	leftJoin(String sql) Deprecated. - Use leftOuterJoin(String) instead
SelectOnStep	leftJoin(String sql, Object... bindings) Deprecated. - Use leftOuterJoin(String, Object...) instead
SelectOnStep	leftJoin(TableLike<?> table) Deprecated. - Use leftOuterJoin(TableLike) instead
SelectOnStep	leftOuterJoin(String sql) LEFT OUTER JOIN a table and proceed to the next step
SelectOnStep	leftOuterJoin(String sql, Object... bindings) LEFT OUTER JOIN a table and proceed to the next step
SelectOnStep	leftOuterJoin(TableLike<?> table) LEFT OUTER JOIN a table and proceed to the next step
SelectJoinStep	naturalJoin(String sql) NATURAL JOIN a table and proceed to the next step Natural joins are supported by most RDBMS.
SelectJoinStep	naturalJoin(String sql, Object... bindings) NATURAL JOIN a table and proceed to the next step Natural joins are supported by most RDBMS.
SelectJoinStep	naturalJoin(TableLike<?> table) NATURAL JOIN a table and proceed to the next step Natural joins are supported by most RDBMS.
SelectJoinStep	naturalLeftOuterJoin(String sql) NATURAL LEFT OUTER JOIN a table and proceed to the next step Natural joins are supported by most RDBMS.
SelectJoinStep	naturalLeftOuterJoin(String sql, Object... bindings) NATURAL LEFT OUTER JOIN a table and proceed to the next step Natural joins are supported by most RDBMS.
SelectJoinStep	naturalLeftOuterJoin(TableLike<?> table) NATURAL LEFT OUTER JOIN a table and proceed to the next step Natural joins are supported by most RDBMS.
SelectJoinStep	naturalRightOuterJoin(String sql) NATURAL RIGHT OUTER JOIN a table and proceed to the next step Natural joins are supported by most RDBMS.
SelectJoinStep	naturalRightOuterJoin(String sql, Object... bindings) NATURAL RIGHT OUTER JOIN a table and proceed to the next step Natural joins are supported by most RDBMS.
SelectJoinStep	naturalRightOuterJoin(TableLike<?> table) NATURAL RIGHT OUTER JOIN a table and proceed to the next step Natural joins are supported by most RDBMS.
SelectOnStep	rightJoin(String sql) Deprecated. - Use rightOuterJoin(String) instead
SelectOnStep	rightJoin(String sql, Object... bindings) Deprecated. - Use rightOuterJoin(String, Object...) instead
SelectOnStep	rightJoin(TableLike<?> table) Deprecated. - Use rightOuterJoin(TableLike) instead
SelectOnStep	rightOuterJoin(String sql) RIGHT OUTER JOIN a table and proceed to the next step This is only possible where the underlying RDBMS supports it
SelectOnStep	rightOuterJoin(String sql, Object... bindings) RIGHT OUTER JOIN a table and proceed to the next step This is only possible where the underlying RDBMS supports it
SelectOnStep	rightOuterJoin(TableLike<?> table) RIGHT OUTER JOIN a table and proceed to the next step This is only possible where the underlying RDBMS supports it

Methods inherited from interface org.jooq.SelectWhereStep

where, where, where, where, whereExists, whereNotExists

Methods inherited from interface org.jooq.SelectGroupByStep

groupBy, groupBy

Methods inherited from interface org.jooq.SelectHavingStep

having, having, having, having

Methods inherited from interface org.jooq.SelectOrderByStep

orderBy, orderBy, orderBy

Methods inherited from interface org.jooq.SelectLimitStep

limit, limit

Methods inherited from interface org.jooq.SelectFinalStep

forShare, forUpdate, getQuery

Methods inherited from interface org.jooq.Select

except, fetch, fetch, fetch, fetch, fetchAny, fetchLazy, fetchMap, fetchMap, fetchOne, fetchOne, fetchOne, fetchOne, getRecordType, getResult, getSelect, intersect, union, unionAll

Methods inherited from interface org.jooq.Query

execute

Methods inherited from interface org.jooq.TableLike

asTable, asTable

Methods inherited from interface org.jooq.QueryPart

getSQL

Methods inherited from interface org.jooq.Attachable

attach, getConfiguration

Methods inherited from interface org.jooq.Adapter

internalAPI

Methods inherited from interface org.jooq.FieldLike

asField, asField

Methods inherited from interface org.jooq.FieldProvider

getField, getField, getField, getFields, getIndex

Method Detail

join

SelectOnStep join(TableLike<?> table)

INNER JOIN a table and proceed to the next step

join

SelectOnStep join(String sql)

INNER JOIN a table and proceed to the next step

See Also:

Factory.plainSQLCondition(String)

join

SelectOnStep join(String sql,
                  Object... bindings)

INNER JOIN a table and proceed to the next step

See Also:

Factory.plainSQLCondition(String, Object...)

crossJoin

SelectJoinStep crossJoin(TableLike<?> table)

CROSS JOIN a table and proceed to the next step

crossJoin

SelectJoinStep crossJoin(String sql)

CROSS JOIN a table and proceed to the next step

See Also:

Factory.plainSQLCondition(String)

crossJoin

SelectJoinStep crossJoin(String sql,
                         Object... bindings)

CROSS JOIN a table and proceed to the next step

See Also:

Factory.plainSQLCondition(String, Object...)

leftJoin

@Deprecated
SelectOnStep leftJoin(TableLike<?> table)

Deprecated. - Use leftOuterJoin(TableLike) instead

Left join a table and proceed to the next step

leftJoin

@Deprecated
SelectOnStep leftJoin(String sql)

Deprecated. - Use leftOuterJoin(String) instead

Left join a table and proceed to the next step

See Also:

Factory.plainSQLCondition(String)

leftJoin

@Deprecated
SelectOnStep leftJoin(String sql,
                                 Object... bindings)

Deprecated. - Use leftOuterJoin(String, Object...) instead

Left join a table and proceed to the next step

See Also:

Factory.plainSQLCondition(String, Object...)

leftOuterJoin

SelectOnStep leftOuterJoin(TableLike<?> table)

LEFT OUTER JOIN a table and proceed to the next step

leftOuterJoin

SelectOnStep leftOuterJoin(String sql)

LEFT OUTER JOIN a table and proceed to the next step

See Also:

Factory.plainSQLCondition(String)

leftOuterJoin

SelectOnStep leftOuterJoin(String sql,
                           Object... bindings)

LEFT OUTER JOIN a table and proceed to the next step

See Also:

Factory.plainSQLCondition(String, Object...)

rightJoin

@Deprecated
SelectOnStep rightJoin(TableLike<?> table)

Deprecated. - Use rightOuterJoin(TableLike) instead

Right join a table and proceed to the next step

rightJoin

@Deprecated
SelectOnStep rightJoin(String sql)

Deprecated. - Use rightOuterJoin(String) instead

Right join a table and proceed to the next step

See Also:

Factory.plainSQLCondition(String)

rightJoin

@Deprecated
SelectOnStep rightJoin(String sql,
                                  Object... bindings)

Deprecated. - Use rightOuterJoin(String, Object...) instead

Right join a table and proceed to the next step

See Also:

Factory.plainSQLCondition(String, Object...)

rightOuterJoin

SelectOnStep rightOuterJoin(TableLike<?> table)

RIGHT OUTER JOIN a table and proceed to the next step

This is only possible where the underlying RDBMS supports it

rightOuterJoin

SelectOnStep rightOuterJoin(String sql)

RIGHT OUTER JOIN a table and proceed to the next step

This is only possible where the underlying RDBMS supports it

See Also:

Factory.plainSQLCondition(String)

rightOuterJoin

SelectOnStep rightOuterJoin(String sql,
                            Object... bindings)

RIGHT OUTER JOIN a table and proceed to the next step

This is only possible where the underlying RDBMS supports it

See Also:

Factory.plainSQLCondition(String, Object...)

fullOuterJoin

SelectOnStep fullOuterJoin(TableLike<?> table)

FULL OUTER JOIN a table and proceed to the next step

This is only possible where the underlying RDBMS supports it

fullOuterJoin

SelectOnStep fullOuterJoin(String sql)

FULL OUTER JOIN a table and proceed to the next step

This is only possible where the underlying RDBMS supports it

See Also:

Factory.plainSQLCondition(String)

fullOuterJoin

SelectOnStep fullOuterJoin(String sql,
                           Object... bindings)

FULL OUTER JOIN a table and proceed to the next step

This is only possible where the underlying RDBMS supports it

See Also:

Factory.plainSQLCondition(String, Object...)

naturalJoin

SelectJoinStep naturalJoin(TableLike<?> table)

NATURAL JOIN a table and proceed to the next step

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

naturalJoin

SelectJoinStep naturalJoin(String sql)

NATURAL JOIN a table and proceed to the next step

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

See Also:

Factory.plainSQLCondition(String)

naturalJoin

SelectJoinStep naturalJoin(String sql,
                           Object... bindings)

NATURAL JOIN a table and proceed to the next step

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

See Also:

Factory.plainSQLCondition(String, Object...)

naturalLeftOuterJoin

SelectJoinStep naturalLeftOuterJoin(TableLike<?> table)

NATURAL LEFT OUTER JOIN a table and proceed to the next step

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

naturalLeftOuterJoin

SelectJoinStep naturalLeftOuterJoin(String sql)

NATURAL LEFT OUTER JOIN a table and proceed to the next step

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

See Also:

Factory.plainSQLCondition(String)

naturalLeftOuterJoin

SelectJoinStep naturalLeftOuterJoin(String sql,
                                    Object... bindings)

NATURAL LEFT OUTER JOIN a table and proceed to the next step

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

See Also:

Factory.plainSQLCondition(String, Object...)

naturalRightOuterJoin

SelectJoinStep naturalRightOuterJoin(TableLike<?> table)

NATURAL RIGHT OUTER JOIN a table and proceed to the next step

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

naturalRightOuterJoin

SelectJoinStep naturalRightOuterJoin(String sql)

NATURAL RIGHT OUTER JOIN a table and proceed to the next step

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

See Also:

Factory.plainSQLCondition(String)

naturalRightOuterJoin

SelectJoinStep naturalRightOuterJoin(String sql,
                                     Object... bindings)

NATURAL RIGHT OUTER JOIN a table and proceed to the next step

Natural joins are supported by most RDBMS. If they aren't supported, they are simulated if jOOQ has enough information.

See Also:

Factory.plainSQLCondition(String, Object...)