Join tables with duplicate values

[المشرف العام]

I have two sets of data:

1. list of parcel numbers and locations which I am interested in
2. 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.



أكثر...