DBI202Xuất hiện trong 1 đề thi
Which of the following SQL statement to return all rows from both the Mechanic and ServiceMechanic tables, the result will contain NULLs for the missing values on the side without a match?
Các lựa chọn
ASELECT *
FROM Mechanic
FULL OUTER JOIN ServiceMechanic
ON Mechanic.MechanicID = ServiceMechanic.MechanicID;
BSELECT *
FROM Mechanic
FULL OUTER JOIN ServiceMechanic
WHERE Mechanic.MechanicID = ServiceMechanic.MechanicID;
CSELECT *
FROM Mechanic
FULL JOIN ServiceMechanic
WHERE Mechanic.MechanicID = ServiceMechanic.MechanicID;
DSELECT *
FROM Mechanic
FULL JOIN ServiceMechanic