# join

abstract fun join(otherTable: ColumnSet, joinType: JoinType, onColumn: Expression<*>? = null, otherColumn: Expression<*>? = null, lateral: Boolean = false, additionalConstraint: SqlExpressionBuilder.() -> Op<Boolean>? = null): Join

Creates a join relation with otherTable. When all joining options are absent Exposed will try to resolve referencing columns by itself.

#### Parameters

otherTable

ColumnSet to join with.

joinType

See JoinType for available options.

onColumn

The column from a current ColumnSet, may be skipped then additionalConstraint will be used.

otherColumn

The column from an otherTable, may be skipped then additionalConstraint will be used.

additionalConstraint

The condition to join which will be placed in ON part of SQL query.

lateral

Set to true to enable a lateral join, allowing the subquery on the right side to access columns from preceding tables in the FROM clause.

#### Throws

IllegalStateException

If join could not be prepared. See exception message for more details.