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.Data
Assembly: Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 65.0.19510.3242 (65.0.19510.3242)
Syntax
C#
[SerializableAttribute] [PersistenceVersionAttribute(12, 0)] public enum JoinType
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
Supported in: 14.3, 14.2, 14.1, 14.0, 12.5, 12.4, 12.3, 12.2, 12.1, 12.0, 11.8
See Also