I have two sets of data:
- list of parcel numbers and locations which I am interested in
- Address database for the county (shapefile)
In dataset 2 there can be multiple instances of the same parcel number with different addresses.
However in dataset 1 there is only 1 unique instance of each parcel number.
I would like to use dataset 1 to extract ALL instances of the same APN in dataset 2.
I have tried a table join but this will not work since table join looks for one and only one corresponding value for parcel number.
I need all corresponding values.