Joins – Relationships

Automatics Joins

DBxtra will add relationship joins automatically if detected in your database schema.

• You can edit the relationship joins or add them manually.

Create Joins manually

• Select the field to join from one table and drag it to the field to join of the another table.

This will create an INNER join.

Edit Joins

• Double click the join line.
  
• Choose between LEFT, RIGHT and INNER joins.

A INNER join will be presented like this:

A LEFT join will be presented like this:

A RIGHT join will be presented like this:

Remove Joins

• To remove a join select the join line, right click and select Remove .

See also: Sub-Queries