This document is archived and information here might be outdated.  Recommended version.


IRelQueryTableInfo.JoinType Property (ArcObjects .NET 10.5 SDK)
ArcObjects Library Reference (GeoDatabase)  

IRelQueryTableInfo.JoinType Property

Type of table join.

[Visual Basic .NET]
Public ReadOnly Property JoinType As esriJoinType
[C#]
public esriJoinType JoinType {get;}
[C++]
HRESULT get_JoinType(
  esriJoinType* JoinType
);
[C++]

Parameters JoinType [out, retval]
JoinType is a parameter of type esriJoinType

Product Availability

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

Remarks

The JoinType can be either esriLeftInnerJoin or esriLeftOuterJoin. A left outer join ensures that all records in the source are returned. A left inner join will only return rows that have matching key field values. The diagram below illustrates the difference.

 

When using ArcMap's user interface to join data, you can choose between either type of join. Clicking the advanced button on the join data dialog box will display a dialog box that allows you to choose the join type. Here, the "Keep all records" option refers to a left outer join when the "Keep only matching records" option specifies a left inner join.

 

See Also

IRelQueryTableInfo Interface