SQL查询语句来实现根据sa.sample_id分组查询,并将相同的sa.sample_id的su.person_name放在一行用“|”号分开的效果:
SELECT sa.sample_id, GROUP_CONCAT(su.person_name SEPARATOR '|') as person_names
FROM sample_allot sa
LEFT JOIN sys_user su ON su.id = sa.inspection_per
GROUP BY sa.sample_id;