题解 | 查询培训指定课程的员工信息
查询培训指定课程的员工信息
https://www.nowcoder.com/practice/a0ef4574056e4a219ee7d651ba82efef
select a.staff_id, a.staff_name from staff_tb a left join cultivate_tb b on a.staff_id = b.staff_id --打标记 where case when course like '%course3%' then 1 else 0 end =1