You have a table named Subcategories that contains subcategories for socks, vests and helmets.
You have another table named Products that contains products only from the subcategories socks and vests.
You have the following query:
SELECT s.Name, p.Name AS ProductName FROM Subcategories s
OUTER APPLY
(SELECT *
FROM Products pr
WHERE pr.SubcategoryID = s.SubcategoryID) p
WHERE s.Name IS NOT NULL;
You need to predict the results of the query.
What results should the query produce?
A. Name ProductName
----- ----------
Socks Mountain Bike Socks,
Socks Mountain Bike Socks,
Socks Racing Socks,
MSocks Racing Socks,
LVests Classic Vest,
SVests Classic Vest,
MVests Classic Vest,
LHelmets NULL
NULL NULL
B. Name ProductName
----- ----------
Socks Mountain Bike Socks,
Socks Mountain Bike Socks,
Socks Racing Socks,
MSocks Racing Socks,
LVests Classic Vest,
SVests Classic Vest,
MVests Classic Vest,
LHelmets NULL
C. Name ProductName
----- ----------
Socks Mountain Bike Socks,
Socks Mountain Bike Socks,
Socks Racing Socks,
MSocks Racing Socks,
LVests Classic Vest,
SVests Classic Vest,
MVests Classic Vest,
LNULL Mountain Bike Socks,
NULL Mountain Bike Socks,
NULL Racing Socks,
MNULL Racing Socks,
LNULL Classic Vest,
SNULL Classic Vest,
MNULL Classic Vest,
LHelmets NULL
NULL NULL
D. Name ProductName
----- ----------
Socks Mountain Bike Socks,
Socks Mountain Bike Socks,
Socks Racing Socks,
MSocks Racing Socks,
LVests Classic Vest,
SVests Classic Vest,
MVests Classic Vest,
L