Search results

I have two tables: logger_data and MPCable. Logger_data table has hourly gage data records consisting of columns for site_serial (unique for each gage), date-time, water pressure (ch1_data_P), barometric pressure (ch2_data_P), temperature, and other not so very important data. MPCable table has...

I have several queries for each gaging stations that are run to update the data table. All of these queries have a similar structure except for range values, site serials, and CountyID. How do I combine these queries to form a single query that would update records for all the gages? For Gage1...