Joining Queries

Click on Join Query button (or the icon) to join queries from different datasources.

Choose a datasource to join with

Generate or Write Queries

Specify Join Keys and the type of Join. If there are no join keys applicable if you are blending in data across two datasources, leave it empty. Otherwise, specify the keys to join with. Join Keys must be a field returned in the queries.

Examples:

customer=customer AND joinAfield=joinBField

The default join type is INNER JOIN when a join field is present. Other Join types supported: LEFT OUTER JOIN, FULL OUTER JOIN, RIGHT OUTER JOIN and LOOP JOIN. To specify a different join type, add the join type into the Join Fields. Example: FULL OUTER JOIN customer=customer. See Multi-Datasource Joins for more details.