You can join two related entities that have either one to many or many to many relationships. For example, join the account and contact entities to retrieve all accounts and the corresponding contacts.

You cannot join unrelated entities, more than two entities, or join entities that have many to many relationships. If you join entities that have many to many relationships, the Data Integration Service retrieves only those records that satisfy this condition.

The following table describes the join information:

Property	Description
Primary Entity	Primary entity to join in the read operation properties.
1:N Relationships	The corresponding relationships between the primary entity and the linked entity.
Join Type	Type of join that can be inner or outer join. Default is outer join.
Primary Entity Join Attribute	The primary entity join attribute.
Linked Entity Join Attribute	The linked entity join attribute.
Join Expression	Displays the adapter-specific relationship you specify to join two related entities. You can copy this expression and use it when you specify the related entity join information at run-time.