JoinQuery

Has 5 parameters, DestinationQuery, SourceQuery, DestinationMatchField, SourceMatchField, Mode

Description:

For each Record in DestinationQuery, if a record is found in SourceQuery where DestinationMatchField equals SourceMatchField the contents of the Record in SourceQuery will be copied to the Record in DestinationQuery.

The record order of SourceQuery will be sorted by SourceMatchField during this operation.

Mode must be one of the following values:

Note that as part of the prep work for the join, the SourceQuery will be sorted by the SourceMatchField.

If any Field names exist in both the DestinationQuery and the Source Query, the duplicate Fields from the SourceQuery will be given a .Source suffix as they are created in the DestinationQuery. The Field names in the SourceQuery itself are not changed.