Matching GIS Databases

[jawwad_karim]

Hi Community

I would like some support on below please.

I have 2 list of location data as follows:

List 1 contains location code, location name and geo codes

List 2 contains location code, location name and geo codes

The codes in List 1 and 2 are not matching at all however some locations may be same based on location name and geo codes.

Through which software, i can find matching locations between the 2 lists and more importantly it is necessary to have location code next to each other wherever there is a match.

Please support

Regards

Jawwad

[rahmansunbeam]

If the lists are in same db, simple sql can do the job,

select * from list_1, list_2 where geo_code_1=geo_code_2;

or use VLOOKUP in excel.