Share via

2.2.4.6 ST_JoinDirection

  • Article

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

Referenced by: CT_Join

A string ([XMLSCHEMA2/2] section 3.2.1) that specifies the direction of a Join in a Query. MUST be one of the following values.

Value

Meaning

Inner

The join results include data from rows in the left input source and the right input source where the LeftProperty and RightProperty values are equal.

Left Outer

The join results include data from all rows in the left input source along with data from rows in the right input source where the LeftProperty and RightProperty values are equal.

Right Outer

The join results include data from all rows in the right input source along with data from rows in the left input source where the LeftProperty and RightProperty values are equal.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this simple type.

 <xsd:simpleType name="ST_JoinDirection">
   <xsd:restriction base="xsd:string">
     <xsd:enumeration value="Inner" wbld:cname="Inner"/>
     <xsd:enumeration value="Left Outer" wbld:cname="LeftOuter"/>
     <xsd:enumeration value="Right Outer" wbld:cname="RightOuter"/>
   </xsd:restriction>
 </xsd:simpleType>

See section 5.4 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).