Joining Tables

When two objects referenced with a foreign key relationship are added to the query, they become joined automatically with INNER JOIN. For those servers that do not support the JOIN clause, the query builder adds a condition to the WHERE part of the query.

Note: LEFT JOIN, RIGHT JOIN, and UNION are not supported. Only INNER JOIN is supported for now.
To join two objects manually, perform these steps:
  1. Select the field by which you want to link the object with another field.
  2. Drag the field to the corresponding field of the other object.
    A line connecting the linked fields appears.
    Note: Key cardinality symbols are placed at the ends of link when a corresponding relationship exists in the database.
  3. (Optional) To remove a link between objects:
    1. Select the line.
    2. Press delete.