Issue: Doing a Spacial Join or Selection returns all items.

If you join a layer to a table you may be unable to use that layer in a spacial join to another layer. When using a layer with joins in ArcMap 9.3 you might encounter the issue where all the items in a layer are selected instead of the selection based on your criteria.

The solution is to export the layer with the join to a separate layer file, then use that layer to do the spacial join/selection.