SELECT name, course_id
FROM instructor, teaches
WHERE (instructor.ID , dept_name) = (teaches.ID ,'Biology');
這個寫法沒有見過,改成下面試試
WHERE instructor.ID=teaches.ID and dept_name='Biology';
有問題再追問吧,望采納。