TABLE DRILL_HOLE
HOLE_NUMBER, pp_x, pp_y, pp_z,
MT-07-79, 694554.434, 5759483.136, 656.77
MT-07-85, 699060.23, 5759483.226, 556.078
MT-07-92 , 698985.64, 5745815.845, 745.45
MT-07-97, 694560.95, 5754483.156, 664.07
MT-07-98, 645060.65, 5754483.126, 454.03
MT-07-99, 694060.45, 5754583.145, 444.04
TABLE UDEF_PROBE_RESULTS
PROBE_RESULTS_id, HOLE_NUMBER, gtp, Length, max_grade,
379, MT-07-79, 0.02, 0.6, 0.09
385, MT-07-79, 0.24, 1.9, 0.35
386, MT-07-79, 0.01, 0.4, 0.08
387, MT-07-79, 0.01, 0.4, 0.03
415, MT-07-85, 0. 27, 0.1, 0.02
419, MT-07-85, 0.07, 0.8, 0.14
420, MT-07-85, 0.05, 0.5, 0.22
483, MT-07-97, 0. 37, 0.1, 0.03
484, MT-07-97, 0.01, 0.3, 0.05
485, MT-07-98, 0.04, 0.6, 0.14
489, MT-07-98, 0. 44, 0.1, 0.03
490, MT-07-98, 0. 05, 0.2, 0.02
TABLE UDEF_RADIOMETRIE
RADIOMETRIE_id, HOLE_NUMBER, cps_max, cps_min,
1, MT-07-99, 200, 200,
2, MT-07-85, 163, 50,
4, MT-07-85, 163, 45,
5, MT-07-92, 265, 265,
6, MT-07-97, 188, 107,
9, MT-07-98, 395, 72,
12, MT-07-98, 108, 108,
13, MT-07-98, 245, 107,
17, MT-07-79, 395, 210,
18, MT-07-79, 185, 650,
Je souhaite avoir comme résultat final
DRILL_HOLE.hole_number (unique)
DRILL_HOLE.pp_x
DRILL_HOLE.pp_y
DRILL_HOLE.pp_z
le max de UDEF_RADIOMETRIE.cps_max
le max de UDEF_PROBE_RESULTS.gtp (si 2 identique, choisir le premier)
UDEF_PROBE_RESULTS.Length
UDEF_PROBE_RESULTS.max_grade
Partager