SQL query
Not what you're looking for?
I have attached a Word document defining the dbo.Orders and dbo.Employees tables (Northwind database). The needed query is: List the EmployeeID, LastName, and FirstName of all employees who did not take an order between March 1 and March 7, 1997. USe an outer join. You must include the condition on OrderDate in the ON clause of the outer join.
Purchase this Solution
Solution Summary
It provides SQL query to implement the required tasks. The response received a '5/5' rating from the student who originally posted the questions.
Solution Preview
Use Northwind
GO
Select Distinct ...
Purchase this Solution
Free BrainMass Quizzes
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Basic Networking Questions
This quiz consists of some basic networking questions.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.