SQL Using the WideWorldImporters database and the Sales schema select CustomerName, CreditLimit, PhoneNumber from the ta

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
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

Post by answerhappygod »

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"
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply