I currently have a database of points that contains latitude and longitude. What I want to do is to filter out all the points so that only the ones that are in Texas will show. I have done a spatial join with the target as the points and the join as the state, but it still shows all the points from the original set.
if you have done a spatial join with the state layer, and there is a state name in the point layer now, you can use a definition query to only include points with that state name value included. access the definition query from the layer properties in the definition query tab and use the query builder to make your expression (i.e. [state] = 'Texas')