MySQL表中数据是这样的,有4张表
1、人员信息表
2、报警级别表
3、段制等级表
4、组列表
现在需求是实现这样的查询结果:
搞了好久才 研究出来,分享给大家,少走弯路
sql为:
SELECT
A.AID,
A.NM,
A.DPT,
A.MOBILE,
A.OTEL,
A.EMAIL,
B.NM AS ALMLEVEL,
C.NM AS SDSPT,
A.DUTIES,
A.ADDRESS,
group_concat(D.NM) AS GIDLST
FROM
alar_person A
LEFT JOIN alar_persion_almlevel B ON A.ALMLEVEL = B.NO
LEFT JOIN alar_persion_sdspt C ON A.SDSPT = C.NO
LEFT JOIN sms_sdgrp D ON find_in_set(D.AID, A.GIDLST)
GROUP BY
A.AID;