2.2.3.10 CT_Join
Target namespace: http://schemas.microsoft.com/office/accessservices/2010/12/application
Referenced by: CT_Joins
Description of a single join in a CT_Query (section 2.2.3.18). A join MUST NOT have the same pair of Left and Right attribute values as another join in the same CT_Query (section 2.2.3.18).
Attributes:
Left: An ST_ObjectName (section 2.2.4.1) attribute that specifies the left input source. The input source MUST be listed in the CT_References (section 2.2.3.7) collection of the parent CT_Query element (section 2.2.3.18). If the CT_Reference element (section 2.2.3.6) that specifies the left input source specifies an Alias attribute, then this attribute MUST be that value.
LeftProperty: An ST_LongString (section 2.2.4.4) attribute that specifies the column in the left input source on which to join.
Right: An ST_ObjectName (section 2.2.4.1) attribute that specifies the right input source. The input source MUST be listed in the CT_References (section 2.2.3.7) collection of the parent CT_Query element (section 2.2.3.18). If the CT_Reference element (section 2.2.3.6) that specifies the right input source includes an Alias attribute, then this attribute MUST be that value.
RightProperty: An ST_LongString (section 2.2.4.4) attribute that specifies the column in the right input source on which to join.
Type: An ST_JoinDirection (section 2.2.4.5) attribute that specifies the direction of the join.
The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.
-
<xsd:complexType name="CT_Join"> <xsd:attribute name="Left" type="ST_ObjectName" use="required" wbld:cname="Left"/> <xsd:attribute name="Right" type="ST_ObjectName" use="required" wbld:cname="Right"/> <xsd:attribute name="LeftProperty" type="ST_LongString" use="required" wbld:cname="LeftProperty"/> <xsd:attribute name="RightProperty" type="ST_LongString" use="required" wbld:cname="RightProperty"/> <xsd:attribute name="Type" type="ST_JoinDirection" default="Inner" wbld:cname="Type" use="optional"/> </xsd:complexType>
See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).