Instance Method

join(_:method:on:)

Include the given table in the list of those used by the query, performing an explicit join using the given method and condition(s). Tables are joined left to right.

@discardableResult func join(_ table: any SQLExpression, method: any SQLExpression = SQLJoinMethod.inner, on expression: any SQLExpression) -> Self

Parameters

table: The name of the table to join.
method: The join method to use.
expression: A string containing a join condition.