AND

Combines this expression with another using a logical AND operator.

This infix function creates a compound condition that is true only if both the current expression and the provided expression are true. This is essential for building complex WHERE or HAVING clauses with multiple criteria.

Example

// Find all active employees who are older than 30
// Generates: ("status" = 'active') AND ("age" > 30)
(Employees.status EQ "active") AND (Employees.age GT 30)

Parentheses are often used to group expressions and ensure correct order of evaluation, especially when mixing AND and OR.

Parameters

See also