How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Scott Your Own Question

Scott
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3040
Experience:  MIT Graduate (Math, Programming, Science, and Music)
3546829
Type Your Homework Question Here...
Scott is online now
A new question is answered every 9 seconds

I need help figuring out why I'm getting errors from my sql

Customer Question

I need help figuring out why I'm getting errors from my sql statement. Northwind traders wants to know the following information about their ordrs for products supplied by supplier number 12 and fulfille by employee number 2. Here is my statement:SELECT FirstName, LastName, Emp.EmployeeID, Sup.SupplierID, Pro.SupplierID, CompanyName ASSupplierName, OrderDate, ShippedDate, RequiredDate, Cus.CustomerID, CompanyName ASCustomerName, Pro.ProductID, ProductName, Shi.ShipperID, CompanyName AS ShipperName
FROM Orders
JOIN Employees
ON Emp.EmployeeID = Ord.EmployeeID
JOIN Customers
ON Cus.CustomerID = Ord.CustomerID
JOIN Products
ON Pro.ProductID = Ord.ProductID
JOIN Shippers
ON Shi.ShipperID = Ord.ShipVia
JOIN Sup.SupplierID = Pro.SupplierID
WHERE SupplierID = 12 AND EmployeeID = 2
ORDER BY OrderDate, CustomerIDI'm not quite sure what I'm missing to get my results.
Submitted: 1 year ago.
Category: Homework
Expert:  ATLProg replied 1 year ago.

Hello i can help let me check

Expert:  ATLProg replied 1 year ago.

Can you please provide database ERD or file having listing of each table and columns