Outer subqueries

Inner subqueries

Question $14$

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)$;

JOIN.

FULL JOIN.

Subquery.

Correlated subquery.