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 FULL JOIN Sales.SalesTerritory t ON p.TerritoryId = t.TerritoryId
B.
SELECT p.SalesPersonId, Name AS [Territory]
FROM Sales.SalesPerson p INNER JOIN Sales.SalesTerritory t ON p.TerritoryId = t.TerritoryId
C.
SELECT p.SalesPersonId, t.Name AS [Territory] FROM Sales.SalesPerson p
CROSS JOIN Sales.SalesTerritory t WHERE p.TerritoryId = t.TerritoryId
D.
SELECT p.SalesPersonId, t.Name AS [Territory] FROM Sales.SalesPerson p
CROSS JOIN Sales.SalesTerritory t;