query: SELECT GeoCode2.*, MasterRef.* FROM GeoCode2 INNER JOIN MasterRef ON GeoCode2.LocalPix1 = MasterRef.RefNum2 WHERE GeoCode2.citycode = 'Franklin'
Could not find a city with that code: Franklin