题解 | 查询培训指定课程的员工信息
select a.staff_id, b.staff_name from ( select staff_id, case when course like '%3%' then 1 else 0 end as course from cultivate_tb )a join staff_tb b on a.staff_id=b.staff_id where course=1 order by staff_id;
select a.staff_id, b.staff_name from ( select staff_id, case when course like '%3%' then 1 else 0 end as course from cultivate_tb )a join staff_tb b on a.staff_id=b.staff_id where course=1 order by staff_id;
相关推荐