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符号,选择所有包含匹配字符串的内容