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