MySQL多行查询结果集合并

SELECT
    ocr.id,
    ocr. NAME,
    ocr.sex,
    org. NAME,
    omf.address,
    group_concat(omf. NAME),
    die.die_reason,
    die.die_time,
    die.main_diagnostic,
    org.default_linker_name,
    org.default_linker_tel
FROM
    old_cadre_record AS ocr
    LEFT JOIN death_info AS die ON ocr.id = die.cadre_id
    LEFT JOIN org_info AS org ON ocr.org_id = org.org_id
    LEFT JOIN old_man_family omf ON ocr.id = omf.cadre_id
WHERE
    ocr.die = 1
GROUP BY ocr.id

进行多表查询的时候，如果将相同属性的列结果合并，用group_concat(omf. NAME),group by id将其合并成一列。