SAND CDBMS SQL Reference Guide
SELECT

Joined Table Expression Clause

( joined table expression )
A joined table expression can optionally be enclosed by parentheses. The use of parentheses does not affect the order of processing in this case, since only the AND operator can be used to combine join predicates.

<value expression>
The join condition consists of two value expressions being compared. Either value expression can range from a simple column name to a complex, nested expression involving arithmetic combinations of columns, functions, and constants. Both of the value expressions being compared must reference at least one column from one or the other table being joined.

AND
Multiple join predicates can be combined using the AND Boolean operator only. That is, OR conditions are not permitted in the joined table expression clause.