Would I be rewriting the FROM statement? And if so, do the SELECT and WHERE statements change? After scouring the text/notes thus far I can't find how to go about it. ProductIDĪs I mentioned earlier, we are not allowed to use Inner Join. QuantityįROM Products INNER JOIN ((Employees INNER JOIN Orders ON Employees.EmployeeID = Orders.EmployeeID) INNER JOIN ON Orders.OrderID =. Now, when I construct the query in design mode, this is the code I get: SELECT Products.ProductID, Products.ProductName. The product ID, product name, and quantity ordered for all products ordered on an order taken by an employee with last name Fuller. Instead I need help with how to construct the query.Īs part of an assignment, using the Northwind database via Microsoft Access, I have to construct this query: First and foremost - it is a homework assignment, yet I am not asking for anyone to do it.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |