Data Vault SQL Reference

Back Next

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.
column name: The first column name
argument is a reference to a column from one of the joined tables; the column name
argument following the comparison operator must refer to a column from the other joined table. Comparisons to constants cannot appear in a join predicate.
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.