SELECT
strategy.strategy_id,
strategy.strategy_name,
strategy.used_num,
strategy.material_id,
strategy.material_parts_id,
strategy.problem_category_id,
strategy.reason_category_id,
strategy.del_status,
IFNULL(tepm.bz," ") as bz,
material.material_name,
materialparts.material_parts_name,
reason.reason_category_name ,
GROUP_CONCAT( CONCAT(metype.measure_type_name,":",measure.measure_name) ORDER BY metype.measure_type_name SEPARATOR ';\r\n') AS cs
FROM
t_engineer_strategy strategy
LEFT JOIN t_engineer_strategymeasure strategymeasure ON strategy.strategy_id = strategymeasure.strategy_id
LEFT JOIN t_engineer_measure measure ON strategymeasure.measure_id = measure.measure_id
LEFT JOIN t_engineer_measure_type metype ON measure.measure_type_id = metype.measure_type_id
LEFT JOIN t_engineer_material material ON strategy.material_id = material.material_id
LEFT JOIN t_engineer_material_parts materialparts ON strategy.material_parts_id = materialparts.material_parts_id
LEFT JOIN t_engineer_reason_category reason ON strategy.reason_category_id = reason.reason_category_id
LEFT JOIN t_engineer_tempory_measure tepm ON tepm.strategy_id = strategy.strategy_id
WHERE strategy.del_status=0
GROUP BY
strategy.strategy_id,
strategy.strategy_name,
strategy.used_num,
strategy.material_id,
strategy.material_parts_id,
strategy.problem_category_id,
strategy.reason_category_id,
strategy.del_status,
tepm.bz,
material.material_name,
materialparts.material_parts_name,
reason.reason_category_name
Mysql列转行且排序
最新推荐文章于 2023-07-12 21:47:21 发布