When checked, all features in the target layer are returned in the output, even if the target feature does not have a match in the join layer (a left outer join). When this option is not checked (default), only matching features between the target layer and the join layer are returned in the output (an inner join). Keep all target features is used to determine whether the output includes only matching features, or all features from the target layer. The result layer will contain multiple records of the target feature. Join one to many-This option joins all the matching features in the join layer to the target layer.(option for largest or smallest value) or a date field (option for The order by expression requires either a numeric field With the highest or lowest value in a certain field (Order by). You can choose toД®ither keep the first matching record in the join layer (default) or to keep the matching record If Define which record is kept is selected, only one matching record from the join layer will be used for each target feature. The count of the summarized records will also be added by default. If Add statistics is selected, all matching records will be summarized for each feature in the target layer. The records from the join layer that are used in the join are determined by the Add statistics parameter or the Define which record is kept parameter. Join one to one-This option joins a single feature in the join layer to each feature in the target layer.The following are the two join operations from which to choose: The join operation determines how joins between the target and join layers will be handled if multiple features in the join layer are found to have the same relationship to the target layer. Features are matched when the field values in the join layer are equal to field values in the target layer. The attribute relationship that will determine whether features are joined to each other. Available spatial relationships are as follows: The available relationships depend on the geometry type (point, line, or area) of the layers being joined. The spatial relationship that will determine whether features are joined to each other.

Arcgis 10.3 make join permanant