题解 | 查询培训指定课程的员工信息
查询培训指定课程的员工信息
https://www.nowcoder.com/practice/a0ef4574056e4a219ee7d651ba82efef
SELECT ct.staff_id, st.staff_name FROM cultivate_tb as ct LEFT JOIN staff_tb as st ON ct.staff_id = st.staff_id WHERE ct.course LIKE '%course3%' ORDER BY ct.staff_id
备忘录:记得LIKE选择的wildcard符号,选择所有包含匹配字符串的内容
