Find Us On: Facebook Twitter Rss Feed Blog
Need To Register? Sign Up Login

database systems7

af
af 


need this done asap, I am behind due to late enrolment. Will pay more if need be Attachments Tags
Clarifications

Answers

Answers

sudheer488
sudheer488 



Please find the solution in the attached text file Attachments
Answers.txt (1 K) Download Preview
LEFT(o.EmployeeID , INSTR(o.EmployeID , ',' )- 1 ) as LASTNAME , e.EmployeeID from ((Orders o INNER JOIN [Order Details] od on o.OrderID = od.OrderID) INNER JOIN Products p on od.ProductID = p.ProductID) INNER JOIN Employees e on LASTNAME = e.LastName; --4th Answer SELECT c.CategoryID , c.CategoryName ,

Screenshots
Purchase Answer