使用GROUP_CONCAT + FIND_IN_SET 函数
select b.engine_number,GROUP_CONCAT(code_name) as tran_name
from t_fix_code a
join t_inventory_tmp b ON FIND_IN_SET(a.code,b.engine_number) > 0
group by b.engine_number
使用GROUP_CONCAT + FIND_IN_SET 函数
select b.engine_number,GROUP_CONCAT(code_name) as tran_name
from t_fix_code a
join t_inventory_tmp b ON FIND_IN_SET(a.code,b.engine_number) > 0
group by b.engine_number