You have two tables named SalesPerson and SalesTerritory. You need to create sample data by using a Cartesian product that contains the data from the SalesPerson and SalesTerritory tables.
Which code segment should you use?
A. SELECT p.SalesPersonId,t.Name AS [Territory]
FROM Sales.SalesPerson p
CROSS JOIN Sales.SalesTerritory t
WHERE p.TerritoryId = t.TerritoryId
B. SELECT p.SalesPersonId,t.Name AS [Territory]
FROM Sales.SalesPerson p
CROSS JOIN Sales.SalesTerritory t
C. SELECT p.SalesPersonId,t.Name AS [Territory]
FROM Sales.SalesPerson p
INNER JOIN Sales.SalesTerritory t ON p.TerritoryId = t.TerritoryId
D. SELECT p.SalesPersonId,t.Name AS [Territory]
FROM Sales.SalesPerson p
FULL JOIN Sales.SalesTerritory t ON p.TerritoryId = t.TerritoryId
