DELETE FROM outreach.defaults_and_ranges;
INSERT INTO outreach.defaults_and_ranges(param_id, lower_limit, upper_limit, `default`, lower_flag, upper_flag, units)
SELECT lp.id, lower_range, upper_range,`default`, flag_lower, flag_higher, units
FROM community_monitoring.defaults_and_ranges dr
JOIN outreach.lab_params lp on dr.parameter = lp.param_name