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: String, method: any SQLExpression = SQLJoinMethod.inner, on left: any SQLExpression, _ op: SQLBinaryOperator, _ right: any SQLExpression) -> Self

Parameters

table: The name of the table to join.
method: The join method to use.
left: The left side of a SQLBinaryExpression.
op: A SQLBinaryOperator.
right: The right side of a SQLBinaryExpression.