Referencing CSV file in Select By Attributes SQL query?

المشرف العام

Administrator
طاقم الإدارة
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.



أكثر...
 
أعلى