SQL help

Discussion created by shulu on Oct 25, 2012
Latest reply on Oct 27, 2012 by shulu
I have historical data sets in two separate files (one for fire and the other for weather), with 1000 fires and 100 weather stations, of 50 years. For each fire, I need to extract weather data. But, among total weather stations, for each fire, I need to extract weather data from a station which is closest to the fire event and is recorded on the same date as of the fire event. What SQL shall I use to address these two requirements? I would appreciate any suggestions.