Join Types

This article describes different ways of joining tables.

Arcadia Enterprise supports five types of column connections, otherwise known as joins: inner, left, right, outer, and left outer joins.

Developer Notes:The types of joins available depend on the underlying database. For example:
  • MySQL connections do not support FULL OUTER JOIN operations.
  • SQLite connections do not support FULL OUTER JOIN and RIGHT OUTER JOIN operations.
column connection (join) types
Join Types in Column Connections Interface
Consider. By default, Arcadia Enterprise produces left-hand joins.