Share via

2.2.3.10 CT_Join

  • Article

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).