Use the Peliqan Join wizard to join two tables together, using a so called “Join”. Note that you can join tables from different sources, which is not possible in regular databases. This is possible thanks to Peliqan’s federated query engine.

There are different ways to join data, each explained below:

• Join wizard: select 2 tables (left/right)
• Joins in SQL editor: write your own SQL query with a JOIN statement
• Join formulas: add a column of type “formula” and use a join formula

Join wizard

In the join wizard you can select 2 tables to be joined, a left and a right table.

If you want to join 3 or more tables, you should join 2 tables first, join this resulting table with a third table, and so on.

Joins in SQL query editor

In the SQL query editor, you can write any type of SELECT query, including a query with a JOIN statement.

Join formulas

You can add a formula column in a table, which will show data from another table. Behind the scenes, a join will be performed. Following formulas are available:

• Join_lookup: show a field from matching records in another table
• Join_count: count matching records from another table
• Join_sum: get the sum of one column of matching records from another table
• Join_max: get the maximum of one column of matching records from another table
• Join_min: get the minimum of one column of matching records from another table
• Join_avg: get the average of one column of matching records from another table