leftJoin

Adds a LEFT JOIN clause to the SELECT statement.

A LEFT JOIN returns all rows from the left table, and the matched rows from the right table. If there is no match, the result is NULL from the right side.

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

Example

// Selects all employees and their department names (if any)
val cursor = Employees
    .select(Employees.firstName, Departments.name)
    .leftJoin(Departments)
    .on(Employees.departmentId, Departments.id)
    .execute()

Parameters

See also