题解 | 查询培训指定课程的员工信息
查询培训指定课程的员工信息
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
