Ecto.Query.join/5

Parsed documentation:
View on GitHub
A join query expression.

Receives a model that is to be joined to the query and a condition to
do the joining on. The join condition can be any expression that evaluates
to a boolean value. The join is by default an inner join, the qualifier
can be changed by giving the atoms: `:inner`, `:left`, `:right` or
`:full`. For a keyword query the `:join` keyword can be changed to:
`:inner_join`, `:left_join`, `:right_join` or `:full_join`.

The join condition can be automatically set when doing an association
join. An association join can be done on any association field
(`has_many`, `has_one`, `belongs_to`).

## Keywords examples

       from c in Comment,
      join: p in Post, on: c.post_id == p.id,
    select: {p.title, c.text}

       from p in Post,
      left_join: c in assoc(p, :comments),
    select: {p, c}

## Expressions examples

    Comment
    |> join(:inner, [c], p in Post, c.post_id == p.id)
    |> select([c, p], {p.title, c.text})

    Post
    |> join(:left, [p], c in assoc(p, :comments))
    |> select([p, c], {p, c})
Suggestions:
Please help! Open an issue on GitHub if this assessment is incorrect.