select a.staff_id,staff_name from staff_tb a join cultivate_tb b on a.staff_id=b.staff_id where course like('%course3%')
1 连接表
2 只需要course 包含course3即可
select a.staff_id,staff_name from staff_tb a join cultivate_tb b on a.staff_id=b.staff_id where course like('%course3%')
1 连接表
2 只需要course 包含course3即可