View the Exhibit and examine the description of the EMPLOYEES and DEPARTMENTS
tables. You want to display the LAST_NAME for the employees, LAST_NAME for the
manager of the employees, and the DEPARTMENT_NAME for the employees having 100
as MANAGER_ID. The following SQL statement was written: SELECT m.last_name
“Manager”, e.last_name “Employee”, department_name “Department” FROM employees m
JOIN employees e ON (m.employee_id = e.manager_id) WHERE e.manager_id=100 JOIN
departments d ON (e.department_id = d.department_id); Which statement is true regarding
the output of this SQL statement?
A.
The statement would provide the desired results.
B.
The statement would not execute because the ON clause is written twice.
C.
The statement would not execute because the WHERE clause is wrongly placed.
D.
The statement would not execute because the self join uses the ON clause instead of the
USING clause.
B
not B,’C’ is the correct answer
Only C is correct.
Something like this
SELECT *
FROM Table1 t1 INNER JOIN
Table2 t2 ON t1.ID = t2.ID INNER JOIN
Table3 t3 ON t1.ID = t3.ID INNER JOIN
….
TableN tn ON t1.ID = tn.ID
So it would look like
SELECT *
FROM cart INNER JOIN
dkb ON cart.id = dkb.id INNER JOIN
cdkb ON cart.id = cdkb.id
WHERE cart.cookieId = ‘” . GetCartId() . “‘