Describes which join type that should be used when joining
two tables into a new table.
This is used in the AddColumnsSettings class to specify how
the join should be performed.
Namespace: Spotfire.Dxp.DataAssembly: Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 18.10.8513.5432 (18.10.8513.5432)
Syntax
Members
Member name | Value | Description | |
---|---|---|---|
InnerJoin | 0 | An inner join will produce the intersection between the two tables. | |
LeftOuterJoin | 1 | A left outer join will preserve all rows from the left view and filter out all non matching rows from the right view. | |
RightOuterJoin | 2 | A right outer join will preserve all rows from the right tables and filter out all non matching rows from the left tables. | |
FullOuterJoin | 3 | A full outer join combines the results of both left and right outer joins. | |
LeftSingleMatchJoin | 4 | Similar to a left outer join but in case of duplicate matches, only one of the right rows are selected. It is undefined which row that gets selected. | |
RightSingleMatchJoin | 5 | Similar to a right outer join but in case of duplicate matches, only one of the left rows are selected. It is undefined which row that gets selected. |
Version Information
See Also