问答详情
源自:5-5 练习

我这样写的对不对

我怎么写的都比你们复杂多了 select t3.ci_id ,wm_concat(select t2.stu_name from pm_ci t1 cross join pm_siu t2 group by t1.ci_id where t3.ci_id=t1.ci_id having instr(t1.stu_ids,'1')>0 or instr(t1.stu_ids,'2')>0 or instr(t1.stu_ids,'3')>0 or instr(t1.stu_ids,'4')from pm_ti t3;

提问者:慕的地5429227 2018-07-01 20:04

个回答

  • C_plus
    2018-07-15 18:39:16

    你这个怕是表里面加入了其他数据就要挂啊