Modifica

SqlJoinType Property

  • Articolo

Version: Available or changed with runtime version 1.0.

Sets the data item link type between data items in a query to determine the records that are included in the resulting data set.

Applies to

  • Query Data Item

Property Value

Value Available or changed with Description
LeftOuterJoin runtime version 1.0 The resulting dataset contains every record from the upper data item table, even if a record does not have a matching value in the lower data item for fields that are linked by the DataItemLink Property (Query).
InnerJoin runtime version 1.0 The resulting dataset contains records from data item tables where a match is found between the fields that are linked by the DataItemLink property of the lower data item.
RightOuterJoin runtime version 1.0 The resulting dataset set contains every record from the lower data item table, even if a record does not have a matching value in the upper data item for fields that are linked by the DataItemLink property.
FullOuterJoin runtime version 1.0 The resulting dataset contains all the records from the upper data item table, and all records from the lower data item, including records that do not have a matching value for columns that are linked by the DataItemLink property.
CrossJoin runtime version 1.0 The resulting dataset contains rows that combine each row from the upper data item table with each row from a lower data item table. Cross joins are also called Cartesian products.

Important: Cross Join does not require any comparisons between fields of data items, so the DataItemLink property must be left blank.

Syntax

 SqlJoinType = InnerJoin;

Remarks

When setting up a data item link between two data items, you always set up the SQLJoinType property on the lower data item.

Except for CrossJoin, the SQLJoinType property works together with the DataItemLink property to combine records from tables into a dataset. The DataItemLink property sets up an "equal to" (=) comparison between two or more fields of the data item tables. When the query is run, the query compares each row of the two data items to find records that having matching values for the fields. Records that have matching field values are combined into a row in the resulting dataset. In some cases, there will be records that do not have matching values.

For more information, see Linking and Joining Data Items to Define the Query Dataset.

See Also

Query Object
Properties