select c.ci_id ,wm_concat(s.stu_name) stu_names
from pm_ci c, pm_stu s
where instr(c.stu_ids, s.stu_id)>0
group by c.ci_id;
from pm_ci c, pm_stu s
where instr(c.stu_ids, s.stu_id)>0
group by c.ci_id;
2021-02-23
SELECT
c.CI_ID,
c.STU_IDS,
wm_concat ( CASE WHEN instr( c.STU_IDS, s.STU_ID ) > 0 THEN s.stu_name ELSE NULL END ) stu_id
FROM
PM_CI c,
PM_STU s
GROUP BY
c.CI_ID,
c.STU_IDS;
c.CI_ID,
c.STU_IDS,
wm_concat ( CASE WHEN instr( c.STU_IDS, s.STU_ID ) > 0 THEN s.stu_name ELSE NULL END ) stu_id
FROM
PM_CI c,
PM_STU s
GROUP BY
c.CI_ID,
c.STU_IDS;
2020-10-13
SELECT
c.CI_ID,
c.STU_IDS,
wm_concat ( CASE WHEN instr( c.STU_IDS, s.STU_ID ) > 0 THEN s.stu_name ELSE NULL END ) stu_id
FROM
PM_CI c,
PM_STU s
GROUP BY
c.CI_ID,
c.STU_IDS;
c.CI_ID,
c.STU_IDS,
wm_concat ( CASE WHEN instr( c.STU_IDS, s.STU_ID ) > 0 THEN s.stu_name ELSE NULL END ) stu_id
FROM
PM_CI c,
PM_STU s
GROUP BY
c.CI_ID,
c.STU_IDS;
2020-10-13