sm1.setting_id, sm1.measurement_date sd.selection_method_type sd.sample_expansion_factor, sc.selection_criteria_no, sc.subpop_code_value, sc.subpop, sc.subpop_min_value, sc.subpop_max_value FROM nrv_setting_measurements sm1, nrv_sample_designs sd, nrv_selection_criteria sc WHERE sm1.setmeas_cn_of IS NULL AND sm1.cn = sd.setmeas_cn AND sd.cn = sc.design_cn AND sm1.level_1_alias = ‘STAND’ AND sm1.project_name = ‘BROOKSTON’ AND sm1.setting_id = ‘091902007040003’ AND (sm1.region_proc = OR sm1.region_admin = ‘09’ ‘09’) AND (sm1.forest_proc = OR sm1.forest_admin = ‘19’ ‘19’) 15 SELECT sm1.project_name, sm1.setting_id, sm1.measurement_date, sm2.level_2_id, FROM nrv_setting_measurements sm1, nrv_setting_measurements sm2, nrv_tree_measurements tm WHERE sm1.setmeas_cn_of IS NULL AND sm1.cn = sm2.setmeas_cn_of AND sm2.cn = tm.setmeas_cn AND sm1.level_1_alias = --AND sm1.project_name = ‘BROOKSTON’ AND sm1_setting_id = ‘091902007040003’ AND (sm1.region_proc = OR sm1.region_admin = ‘09’ ‘09’) AND (sm1.forest_proc = OR sm1.forest_admin = ‘19’ ‘19’) AND sm1.measurement_date = (SELECT MAX(sm1_i.measurement_date) FROM nrv_setting_measurements sm1_i WHERE sm1_i.setmeas_cn_of IS NULL AND = sm1.setting_id GROUP BY sm1_i.setting_id)
sm1.setting_id, sm1.measurement_date sd.selection_method_type sd.sample_expansion_factor, sc.selection_criteria_no, sc.subpop_code_value, sc.subpop, sc.subpop_min_value, sc.subpop_max_value FROM nrv_setting_measurements sm1, nrv_sample_designs sd, nrv_selection_criteria sc WHERE sm1.setmeas_cn_of IS NULL AND sm1.cn = sd.setmeas_cn AND sd.cn = sc.design_cn AND sm1.level_1_alias = ‘STAND’ AND sm1.project_name = ‘BROOKSTON’ AND sm1.setting_id = ‘091902007040003’ AND (sm1.region_proc = ‘09’ OR sm1.region_admin = ‘09’) AND (sm1.forest_proc = ‘19’ OR sm1.forest_admin = ‘19’) 15 SELECT sm1.project_name, sm1.setting_id, sm1.measurement_date, sm2.level_2_id, FROM nrv_setting_measurements sm1, nrv_setting_measurements sm2, nrv_tree_measurements tm WHERE sm1.setmeas_cn_of IS NULL AND sm1.cn = sm2.setmeas_cn_of AND sm2.cn = tm.setmeas_cn AND sm1.level_1_alias = --AND sm1.project_name = ‘BROOKSTON’ AND sm1_setting_id = ‘091902007040003’ AND (sm1.region_proc = ‘09’ OR sm1.region_admin = ‘09’) AND (sm1.forest_proc = ‘19’ OR sm1.forest_admin = ‘19’) AND sm1.measurement_date = (SELECT MAX(sm1_i.measurement_date) FROM nrv_setting_measurements sm1_i WHERE sm1_i.setmeas_cn_of IS NULL AND = sm1.setting_id GROUP BY sm1_i.setting_id)
QueryingFSVeg.docx