The following code is an example of a: SELECT CustomerName, CustomerAddress, CustomerCity, CustomerState,
CustomerPostalCode
FROM Customer_T
WHERE Customer_T.CustomerID =
(SELECT Order_T.CustomerID
FROM Order_T
WHERE OrderID = 1008);
A) Correlated subquery.
B) Subquery.
C) JOIN.
D) FULL OUTER JOIN.

Question

Quizplus · Accepted Answer

The query uses a subquery to select the CustomerID from the Order_T table where OrderID is 1008, and then uses that result to select specific fields from the Customer_T table. This is a simple example of a subquery, where the result of the inner query is used as a filter for the outer query.

The Following Code Is an Example of A: SELECT CustomerName