Based on the tables below, which command creates a new table named CustSales that combines the Customer and SalesPerson tables based on SalesPersonNum??Customer (CustomerNum, CustomerName, Street, City, State, PostalCode, SalesPersonNum)?SalesPerson (SalesPersonNum, LastName, FirstName)
A) PROJECT Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum MAKING CustSales
B) UNION Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum MAKING CustSales
C) SELECT Customer SalesPerson JOIN Customer.SalesPersonNum=SalesPerson.SalesPersonNum GIVING CustSales
D) JOIN Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum GIVING CustSales

Question

Quizplus · Accepted Answer

The correct command to create a new table named CustSales that combines the Customer and SalesPerson tables based on SalesPersonNum is the JOIN command. The WHERE clause should specify the condition for the join, which is Customer.SalesPersonNum=SalesPerson.SalesPersonNum. The resulting table should be named CustSales using the GIVING keyword. Therefore, the correct command is JOIN Customer SalesPerson WHERE Customer.SalesPersonNum=SalesPerson.SalesPersonNum GIVING CustSales.

Based on the Tables Below, Which Command Creates a New