A teacher has a table named Class that contains the names of the students in the teacher's class and a table named After$-$School that contains the names of the students in the school's after$-$school program.

The Class table is on the left and the After$-$School table is on the right.

Which type of join should you use to build a view that displays only the students in the class that attend the after$-$school program?

Full Outer

Right

Inner

Left