insert into DisckDB.RevGeoMetriHistory
    (
		 	Service,
			Lat,
			Lon,
			PlaceName,
			CandidatePlaceName,
			Elevation,
			InqTime,
			UserName
    )
select temp_RevGeoMetriHistory.Service, 
       temp_RevGeoMetriHistory.Lat, 
       temp_RevGeoMetriHistory.Lon, 
       temp_RevGeoMetriHistory.PlaceName, 
       temp_RevGeoMetriHistory.CandidatePlaceName,
       temp_RevGeoMetriHistory.Elevation, 
       temp_RevGeoMetriHistory.InqTime, 
       temp_RevGeoMetriHistory.UserName
  from temp_RevGeoMetriHistory
		left join  DisckDB.RevGeoMetriHistory
		on (temp_RevGeoMetriHistory.Service = DisckDB.RevGeoMetriHistory.Service) 	and 
		   (temp_RevGeoMetriHistory.Lat     = DisckDB.RevGeoMetriHistory.Lat) 			and
		   (temp_RevGeoMetriHistory.Lon     = DisckDB.RevGeoMetriHistory.Lon)
where  ((DisckDB.RevGeoMetriHistory.ID) is null)