BUG
** This issue is addressed in ArcGIS 9.0 Service Pack 3 (SP3) **
If a table was joined to a shapefile using the 'Keep only matching records' option, and a definition query was created using fields from both the table and the shapefile, then the data disappeared from the map view.
Get help from ArcGIS experts
Download the Esri Support App