Question

In the SQL query below, the Teacher table is the _____.

SELECT LastName, FirstName, CourseTitle
FROM Teacher
INNER JOIN Class
ON Teacher.TeacherID = Class.TeacherID;
a. Left table
b. Right table
c. Main table
d. Source table

Answer 1

In the SQL query, the Teacher table is the left table because it is mentioned first in the INNER JOIN operation with the Class table.

Step-by-step explanation:

In the SQL query provided, the Teacher table acts as the left table in the context of the INNER JOIN operation with the Class table. This terminology is based on the order of the tables as they appear in the SQL statement. The Teacher table is mentioned first and then joined with the Class table using their respective TeacherID fields, hence it is referred to as the left table. In SQL joins, the left table is the one that appears first in the JOIN clause. Similarly, the table that comes second is often referred to as the right table.

The correct answer to the question is, therefore:

• a. Left table