joinQuery

fun Join.joinQuery(on: SqlExpressionBuilder.(QueryAlias) -> Op<Boolean>? = null, joinType: JoinType = JoinType.INNER, lateral: Boolean = false, joinPart: () -> AbstractQuery<*>): Join

Creates a join relation with a query.

Parameters

on

The condition to join that will be placed in the ON clause.

joinType

The JOIN clause type used to combine rows. Defaults to JoinType.INNER.

joinPart

The query to join with.

Samples

org.jetbrains.exposed.sql.tests.shared.AliasesTests.testJoinSubQuery02
fun Table.joinQuery(on: SqlExpressionBuilder.(QueryAlias) -> Op<Boolean>? = null, joinType: JoinType = JoinType.INNER, lateral: Boolean = false, joinPart: () -> AbstractQuery<*>): Join

Creates a join relation between this table and a query.

Parameters

on

The condition to join that will be placed in the ON clause.

joinType

The JOIN clause type used to combine rows. Defaults to JoinType.INNER.

joinPart

The query to join with.