JoinOperator in sqlparser::ast - Rust

pub enum JoinOperator {
Show 18 variants Join(JoinConstraint), Inner(JoinConstraint), Left(JoinConstraint), LeftOuter(JoinConstraint), Right(JoinConstraint), RightOuter(JoinConstraint), FullOuter(JoinConstraint), CrossJoin(JoinConstraint), Semi(JoinConstraint), LeftSemi(JoinConstraint), RightSemi(JoinConstraint), Anti(JoinConstraint), LeftAnti(JoinConstraint), RightAnti(JoinConstraint), CrossApply, OuterApply, AsOf { match_condition: Expr, constraint: JoinConstraint, }, StraightJoin(JoinConstraint),
}
Expand description

The operator used for joining two tables, e.g. INNER, LEFT, CROSS, ASOF, etc.

§

Generic JOIN with an optional constraint.

§

INNER JOIN with an optional constraint.

§

LEFT JOIN with an optional constraint.

§

LEFT OUTER JOIN with an optional constraint.

§

RIGHT JOIN with an optional constraint.

§

RIGHT OUTER JOIN with an optional constraint.

§

FULL OUTER JOIN with an optional constraint.

§

CROSS JOIN (constraint usage is non-standard).

§

SEMI JOIN (non-standard)

§

LEFT SEMI JOIN (non-standard)

§

RIGHT SEMI JOIN (non-standard)

§

ANTI JOIN (non-standard)

§

LEFT ANTI JOIN (non-standard)

§

RIGHT ANTI JOIN (non-standard)

§

CROSS APPLY (non-standard)

§

OUTER APPLY (non-standard)

§

Fields

Condition used to match records in the ASOF join.

Additional constraint applied to the ASOF join.

§

§
§
§
§
§
§