join

Adds a JOIN clause to the SELECT statement.

By default, this performs an INNER JOIN. To specify a different join type, use innerJoin, leftJoin, rightJoin, fullJoin, or crossJoin.

After calling this method, you must specify the join condition using the on or using methods provided by the returned JoinStatement.

Example

val cursor = Employees
    .select()
    .join(Departments)
    .on(Employees.departmentId, Departments.id)
    .execute()

Parameters

See also