SELECT s.staff_id, s.staff_name FROM staff_tb s JOIN cultivate_tb c ON s.staff_id=c.staff_id WHERE c.course LIKE '%course3%' ORDER BY s.staff_id ASC
LIKE + 通配符 %,匹配字段
SELECT s.staff_id, s.staff_name FROM staff_tb s JOIN cultivate_tb c ON s.staff_id=c.staff_id WHERE c.course LIKE '%course3%' ORDER BY s.staff_id ASC
LIKE + 通配符 %,匹配字段