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"
SQL Using the WideWorldImporters database and the Sales schema select CustomerName, CreditLimit, PhoneNumber from the ta
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
SQL Using the WideWorldImporters database and the Sales schema select CustomerName, CreditLimit, PhoneNumber from the ta
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!