1. Home
  2. Docs
  3. ADMIN user
  4. Query Your Data
  5. Add Tables to the Query
  6. Joins – Relationships

Joins – Relationships

Automatics Joins

XLReport 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.

Remove Joins

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