I have 2 databases:
Database 1: Point Shapefile with adress and APN (parcel numbers) as attributes. (Huge number of points, addresses for an entire metropolitan area).
Database 2: CSV file with a smaller database of addresses and APN numbers, and a few other fields. This one is not georeferenced.
I would like to construct a query in Select by Attributes where I reference database 2 and search for APN's within database 1 corresponding to all the ones in database 2. Ultimately I would like to isolate all corresponding points and display them on the map.
This is like a batch form of the following query:
SELECT*FROM ADDRESS_APN WHERE "APN" = '###' AND "APN"='####' AND ......
Only thing is there are about 565 values so it is unfeasible to have an AND statement for each value. I would much rather reference the CSV file.