Creates a new Table by joining the tables defined in the TableRelationship which contains only the specified columns and only those rows which satisfy the search criteria and are matched in both tables.

Namespace:  ESRI.ArcGISExplorer.Data

Assembly:  ESRI.ArcGISExplorer (in ESRI.ArcGISExplorer.dll) Version: 2.0.0.1500 (2.0.0.1500)

Syntax

C#
public Table CreateJoinedTable(
	TableJoinType joinType,
	Filter filter,
	string[] destinationColumns
)
Visual Basic (Declaration)
Public Function CreateJoinedTable ( _
	joinType As TableJoinType, _
	filter As Filter, _
	destinationColumns As String() _
) As Table

Parameters

joinType
Type: ESRI.ArcGISExplorer.Data..::.TableJoinType

One of the TableJoinType values which, in conjunction with the filter, determines the content of the joined table.
filter
Type: ESRI.ArcGISExplorer.Data..::.Filter

A Filter object containing additional search criteria which, in conjunction with the joinType, determines the content of the joined table.
destinationColumns
Type: array< System..::.String >[]()[]

A array of column names used to define the new joined table.

Return Value

A new Table object which is the result of joining the tables defined in the TableRelationship.

Remarks

Joins can only be performed where the relationship Cardinality is one-to-one. Performance will be improved if the columns participating in the join are indexed. When accessing columns in the joined table by name, use the fully qualified form: "table_name.column_name". Using the Table.Join method avoids the need to explicitly create a TableRelationship when joining two tables, but does not have the flexibility to specify additional search criteria or define which columns to return.

See Also