Skip to main content

in_subquery

drizzle_core::expr

Function in_subquery 

Source 
pub fn in_subquery<'a, V, L, S, M>(
    lhs: L,
    subquery: S,
) -> SQLExpr<'a, V, <V::DialectMarker as DialectTypes>::Bool, NonNull, L::Aggregate>
where
    V: SQLParam + 'a,
    L: InSubqueryLhs<'a, V, M>,
    S: Expr<'a, V>,
    L::SQLType: Compatible<S::SQLType>,
Expand description

IN subquery check.

Returns true if the expression’s value is in the subquery results. Accepts a single expression or a tuple of expressions as the LHS:

in_subquery(users.id, sub)                      // single column
in_subquery((users.id, users.name), sub)        // multi-column