ArcObjects Library Reference (GeoDatabase)  

IRelQueryTable Interface

Provides access to members that define the Tables and the RelationshipClass used in a join.

Product Availability

Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.

Members

Description
Read-only property DestinationTable The fields that appear on the right side of the join belong to the destination table.
Read-only property RelationshipClass Relationship class used in the table join.
Read-only property SourceTable The fields that appear on the left side of the join belong to the source table.

CoClasses that implement IRelQueryTable

CoClasses and Classes Description
RelQueryTable An object that joins two datasets based on common data values.

Remarks

The IRelQueryTable interface allows you to get the source and destination as well as the RelationshipClass or MemoryRelationshipClass used to define the RelQueryTable. The source and destination can be Tables, FeatureClasses, or even other RelQueryTables.

For example, if you wanted to join two tables to a feature class, you would first create RelQueryTableA to join one of the tables to the feature class. You would then create RelQueryTableB to join the second table to RelQueryTableA. RelQuerytableA would be the source for RelQueryTableB. The diagram below illustrates how this works.