04 LeftJoin - AndrewMB2/Logic-Architect-for-Excel-VBA GitHub Wiki

LeftJoin method

Carries out a left join to another Xdata object. Returns True if successful, otherwise False.

Applies to

TableData ArrData RsetData Xdata XShared

Parameters

Name Type Description
Xd Xdata The Xdata object to which this object will be joined.
JoinFields Value or Array or ParamArray List of fields common to both objects which will be matched.
CopyFields Value, Array or ParamArray List of fields to be brought in.

LeftJoin caries out a left join to another ArrData object or a TableData object (to bring in fields from matching records). It is possible to match on any number of fields (which are specified in the JoinFields parameter). It then brings in the required fields (specified in the CopyFields parameter) which must be present in the ArrData object, or all fields with matching names if none are specified. All matched and required fields must have the same name in both objects (use Rename if necessary).