Example 5.9.3 To retrieve the names of instructors who taught cs110 we can execute in SQL Plus the query:
select distinct INSTRUCTORS.name
from INSTRUCTORS inner join GRADES using(empno);
The inner join can be used for joins that involve more than two tables.