Only matching records are preserved when creating a Join through the Layer Properties > Joins and Relates tab

Last Published: April 25, 2020


**This issue appears with ArcGIS 9.l, Service Pack 2**

If a Join is established in the Layer Properties > Joins and Relates tab, only matching records are preserved. This occurs even if the default of 'Keep All Records' is selected.


This is a known limitation.


Establish the join through the layer context menu, or with the Add Join tool from ArcToolbox.

    Article ID:000008900

    • ArcMap 9 x

    Get help from ArcGIS experts

    Contact technical support

    Download the Esri Support App

    Go to download options

    Discover more on this topic