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.testJoinSubQuery02fun 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.