题解 | 查询培训指定课程的员工信息
查询培训指定课程的员工信息
https://www.nowcoder.com/practice/a0ef4574056e4a219ee7d651ba82efef
select
s.staff_id ,
s.staff_name
from staff_tb s
inner join cultivate_tb c
on s.staff_id = c.staff_id
where c.course like '%course3%'
查询培训指定课程的员工信息
https://www.nowcoder.com/practice/a0ef4574056e4a219ee7d651ba82efef
select
s.staff_id ,
s.staff_name
from staff_tb s
inner join cultivate_tb c
on s.staff_id = c.staff_id
where c.course like '%course3%'
相关推荐