DBxtra Documentation

DBxtra Documentation

How Can We Help?

Joins – Relationships

< All Topics

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 LEFTRIGHT 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

Previous Add Tables / Views and Report Objects to the Query
Next Sub-Queries
Table of Contents