Share via

2.2.3.12 CT_Join

  • Article

Target namespace: http://schemas.microsoft.com/office/accessservices/2009/11/application

Referenced by: CT_Joins

Description of a single join in a Query. A join MUST NOT have the same pair of Left and Right attribute values as another join in the same Query.

Attributes:

Left : An ST_ObjectName attribute that specifies the left input source. The input source MUST be listed in the References collection of the Query. If the Reference includes an Alias attribute, then this attribute MUST be that value.

LeftProperty : An ST_LongString attribute that specifies the column (1) in the left input source on which to join.

Right : An ST_ObjectName attribute that specifies the right input source. The input source MUST be listed in the References collection of the Query. If the Reference includes an Alias attribute, then this attribute MUST be that value.

RightProperty : An ST_LongString attribute that specifies the column (1) in the right input source on which to join.

Type : An ST_JoinDirection 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.4 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).