SAND CDBMS SQL Reference Guide
Joins

When a FROM clause contains two or more tables (or views), that FROM clause is said to join the data values appearing in the two or more listed tables. Any number of table or view names may be listed in a FROM clause, with each object name separated from the others by a comma.

SAND CDBMS supports the following join types:

• INNER JOIN
• OUTER JOINS
  • FULL [OUTER] JOIN
  • LEFT [OUTER] JOIN
  • RIGHT [OUTER] JOIN
• MATCH JOINS
  • LEFT MATCH JOIN
  • RIGHT MATCH JOIN
• Nested Joins
• Materialized Joins