Open topic with navigation

About Meridium Inner Joins

When you use two related entity families as query sources, Meridium Enterprise APM creates an inner join between the two entity families by default. This inner join causes the query results to include only the records that are linked through the specified relationship.

If two entity families are not related through a relationship family, you can manually create an inner join to connect one or more fields in one family to one or more fields in the other family.

The following table shows the line style that appears in the design canvas to represent Meridium inner joins.

Join Type	Line Style
Meridium Inner Join

Example: Inner Join

Suppose you add the Equipment entity family, Work History entity family, and Has Work History relationship family as query sources. Assuming that the Has Work History family relates the Equipment family to the Work History family, Meridium Enterprise APM will create an inner join between the Equipment and Work History families by default. As a result, the query results will return only Equipment records that are linked to a Work History record through the Has Work History relationship. The query results will not include any Equipment records that are not linked to a Work History record or any Work History records that are not linked to an Equipment record.

Copyright © 1993-2015 Meridium, Inc. All rights reserved.