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