题解 | 查询培训指定课程的员工信息

select
        a.staff_id,
        st.staff_name
from (
    select
        staff_id
    from
            cultivate_tb
    where
            course like '%course3%'
)a
inner join 
        staff_tb as st
on 
        a.staff_id = st.staff_id