题解 | 查询培训指定课程的员工信息
SELECT st.staff_id, st.staff_name
FROM staff_tb as st
RIGHT JOIN(
SELECT *
FROM cultivate_tb as ct
WHERE course like "%course3%"
) as ct ON st.staff_id = ct.staff_id
GROUP BY st.staff_id, st.staff_name
SELECT st.staff_id, st.staff_name
FROM staff_tb as st
RIGHT JOIN(
SELECT *
FROM cultivate_tb as ct
WHERE course like "%course3%"
) as ct ON st.staff_id = ct.staff_id
GROUP BY st.staff_id, st.staff_name
相关推荐
王海:不算mentor但也带过几个实习生,直接观感就是你可以摸鱼可以想早下班,分给你的工作好好完成就行