SELECT a.No,a.EmpNo,a.Name,a.Email,a.Tel,b.FK_Duty,b.FK_Dept,d.Name as DetpName, c.Name as DutyName, b.DutyLevel,b.Leader,
(SELECT ','+GROUP_CONCAT(e.Name) FROM Port_DeptEmpStation d,Port_Station e
WHERE d.FK_Station = e.No AND d.FK_Emp=a.no )
AS Stations FROM Port_Emp a, Port_DeptEmp b , Port_Duty c,Port_Dept d
WHERE A.No=B.FK_Emp AND b.FK_Duty=c.No and b.FK_Dept=d.No
and (a.No like '%admin%' OR a.Name like '%admin%' OR a.EmpNo like '%admin%') order by a.No;
为什么有insert
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024