BUG
**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.
Article ID:000008900
Get help from ArcGIS experts
Download the Esri Support App