pub enum JoinOperator {
Show 18 variants
Join(JoinConstraint),
Inner(JoinConstraint),
Left(JoinConstraint),
LeftOuter(JoinConstraint),
Right(JoinConstraint),
RightOuter(JoinConstraint),
FullOuter(JoinConstraint),
CrossJoin,
Semi(JoinConstraint),
LeftSemi(JoinConstraint),
RightSemi(JoinConstraint),
Anti(JoinConstraint),
LeftAnti(JoinConstraint),
RightAnti(JoinConstraint),
CrossApply,
OuterApply,
AsOf {
match_condition: Expr,
constraint: JoinConstraint,
},
StraightJoin(JoinConstraint),
}
Variants§
Join(JoinConstraint)
Inner(JoinConstraint)
Left(JoinConstraint)
LeftOuter(JoinConstraint)
Right(JoinConstraint)
RightOuter(JoinConstraint)
FullOuter(JoinConstraint)
CrossJoin
Semi(JoinConstraint)
SEMI (non-standard)
LeftSemi(JoinConstraint)
LEFT SEMI (non-standard)
RightSemi(JoinConstraint)
RIGHT SEMI (non-standard)
Anti(JoinConstraint)
ANTI (non-standard)
LeftAnti(JoinConstraint)
LEFT ANTI (non-standard)
RightAnti(JoinConstraint)
RIGHT ANTI (non-standard)
CrossApply
CROSS APPLY (non-standard)
OuterApply
OUTER APPLY (non-standard)
AsOf
ASOF
joins are used for joining tables containing time-series data
whose timestamp columns do not match exactly.
See https://docs.snowflake.com/en/sql-reference/constructs/asof-join.
StraightJoin(JoinConstraint)
STRAIGHT_JOIN (non-standard)
Trait Implementations§
Source§impl Clone for JoinOperator
impl Clone for JoinOperator
Source§fn clone(&self) -> JoinOperator
fn clone(&self) -> JoinOperator
Returns a copy of the value. Read more
1.0.0 · Source§fn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
Performs copy-assignment from
source
. Read moreSource§impl Debug for JoinOperator
impl Debug for JoinOperator
Source§impl<'de> Deserialize<'de> for JoinOperator
impl<'de> Deserialize<'de> for JoinOperator
Source§fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>where
__D: Deserializer<'de>,
fn deserialize<__D>(__deserializer: __D) -> Result<Self, __D::Error>where
__D: Deserializer<'de>,
Deserialize this value from the given Serde deserializer. Read more
Source§impl Hash for JoinOperator
impl Hash for JoinOperator
Source§impl Ord for JoinOperator
impl Ord for JoinOperator
Source§fn cmp(&self, other: &JoinOperator) -> Ordering
fn cmp(&self, other: &JoinOperator) -> Ordering
1.21.0 · Source§fn max(self, other: Self) -> Selfwhere
Self: Sized,
fn max(self, other: Self) -> Selfwhere
Self: Sized,
Compares and returns the maximum of two values. Read more
Source§impl PartialEq for JoinOperator
impl PartialEq for JoinOperator
Source§impl PartialOrd for JoinOperator
impl PartialOrd for JoinOperator
Source§impl Serialize for JoinOperator
impl Serialize for JoinOperator
Source§impl Spanned for JoinOperator
§partial span
Missing spans:
impl Spanned for JoinOperator
§partial span
Missing spans:
Source§impl Visit for JoinOperator
impl Visit for JoinOperator
Source§impl VisitMut for JoinOperator
impl VisitMut for JoinOperator
fn visit<V: VisitorMut>(&mut self, visitor: &mut V) -> ControlFlow<V::Break>
impl Eq for JoinOperator
impl StructuralPartialEq for JoinOperator
Auto Trait Implementations§
impl Freeze for JoinOperator
impl RefUnwindSafe for JoinOperator
impl Send for JoinOperator
impl Sync for JoinOperator
impl Unpin for JoinOperator
impl UnwindSafe for JoinOperator
Blanket Implementations§
Source§impl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere
T: ?Sized,
Source§fn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more