SQL Using the WideWorldImporters database and the Sales schema select CustomerName, CreditLimit, PhoneNumber from the ta
Posted: Thu Jul 14, 2022 2:10 pm
SQL Using the WideWorldImporters database and the Sales schema select CustomerName, CreditLimit, PhoneNumber from the table Customers and the corresponding CustomerCategoryName, ValidFrom, and ValidTo from the CustomerCategories table. Review the columns to determine how to join the tables. Take a screen shot of the SQL windows and results and paste it here
Use WideWorldImporters
Go
SELECT CustomerName, CreditLimit, PhoneNumber
FROM Sales.Customers
INNER JOIN
SELECT CustomerCategoryName, ValidFrom, ValidTo
FROM Sales.Customers
What am I doing wrong? It keeps saying incorrect Syntax for "Select"
Use WideWorldImporters
Go
SELECT CustomerName, CreditLimit, PhoneNumber
FROM Sales.Customers
INNER JOIN
SELECT CustomerCategoryName, ValidFrom, ValidTo
FROM Sales.Customers
What am I doing wrong? It keeps saying incorrect Syntax for "Select"