Joins
When configuring the Block Properties Include tab source Blocks, including the Query Block and the Fetch Block, or target operation Inner and outer joins are represented as follows:
- Return records with or without relationship —This option is an outer join and returns all records for the higher-level entity whether or not there are any matching related entity records. For example, if contact is the higher-level entity and account is the related entity, all contact records are returned whether there is a related account record or not.
- Return only records with relationship — This option is an inner join and returns records for the higher-level entity with one or more matching related entity records. For example, if contact is the higher-level entity and account is the related entity, only contact records with at least one related account record are returned.
In the case of multiple levels of nested entities, if a record has no related records, this affects records below it but not above it in the hierarchy. For example, assume a Country has Zero or More States, and a State has Zero or More Cities, and you have selected Return only records with relationship between the state and the city. If a particular state has no cities, the state is excluded from the source data, but this does not move up the hierarchy and cause the whole country to be excluded.