oracle 一对多查询，需要合并成一条数据，只需要名细中的某个字段，并把这个字段组合到某一个字段中；

SELECT t.bar_codes,min(t.status) as status,min(t.result) as result,  LISTAGG( distinct j.measurement_machine, ',')  WITHIN GROUP (ORDER BY j.measurement_machine ) AS  machine
   FROM  MEASUREMENT_DATA t JOIN MEASUREMENT_LIST_DATA j ON t.bar_codes = j.bar_code
   GROUP BY bar_codes;