题解 | 查询培训指定课程的员工信息
查询培训指定课程的员工信息
https://www.nowcoder.com/practice/a0ef4574056e4a219ee7d651ba82efef
SELECT
staff_id,
staff_name
FROM staff_tb st
JOIN cultivate_tb ct USING (staff_id)
WHERE ct.course LIKE "%course3%"
查询培训指定课程的员工信息
https://www.nowcoder.com/practice/a0ef4574056e4a219ee7d651ba82efef
SELECT
staff_id,
staff_name
FROM staff_tb st
JOIN cultivate_tb ct USING (staff_id)
WHERE ct.course LIKE "%course3%"
相关推荐