KQLite/com.kqlite.statement/JoinStatement

JoinStatement

interface JoinStatement<T : KQLiteTable>

Represents a statement for defining the JOIN condition in a KQLite query. This is typically used after specifying the tables to join (INNER JOIN, LEFT JOIN, etc.).

Example

    Artists
       .select(Artists.artistId, Artists.artistName, Albums.title)
       .join(Albums, JoinType.LEFT_JOIN)
       .using(Artists.artistId)
       .execute()

Type Parameters

The primary table type for the select statement.

Inheritors

SelectStatement

Functions

abstract fun <C> on(left: KQLiteColumn<C>, right: KQLiteColumn<C>): SelectStatement<T>

Same as calling on(left, right, JoinOp.EQ, null, null)

abstract fun <C> on(left: KQLiteColumn<C>, right: KQLiteColumn<C>, joinOp: JoinOp = JoinOp.EQ, and: Clause.() -> Unit? = null, or: Clause.() -> Unit? = null): SelectStatement<T>

Specifies the ON condition for a JOIN clause.

using

abstract fun using(column: KQLiteColumn<*>): SelectStatement<T>

Specifies a USING clause for a JOIN operation.