最后一题我好像做出来了
select ci_id,wm_concat(stu_name)
from pm_ci a,pm_stu b
where instr(a.stu_ids,b.stu_id)>0
group by ci_id
虽然可以得出和要求一样的结果
但是我也是蒙出来的
自己都看不懂
select ci_id,wm_concat(stu_name)
from pm_ci a,pm_stu b
where instr(a.stu_ids,b.stu_id)>0
group by ci_id
虽然可以得出和要求一样的结果
但是我也是蒙出来的
自己都看不懂
2016-11-25
select c.ci_id,wm_concat(s.stu_name)
from pm_ci c, pm_stu s
where instr(c.stu_ci,s.stu_id) >0
group by ci_id;
from pm_ci c, pm_stu s
where instr(c.stu_ci,s.stu_id) >0
group by ci_id;