Instance Method

join(_:method:using:)

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

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

Parameters

table: The name of the table to join.
method: The join method to use.
columns: One or more columns to use to perform a NATURAL JOIN.