question

rnofx5 avatar image
rnofx5 asked

Write a sub-query that returns employees who did not place orders on or after May 1st, 1998. Include the employeeid, last and first names

Write a sub-query that returns employees who did not place orders on or after May 1st, 1998. Include the employeeid, last and first names
sqlsub-queryorder-by
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Homework ? Due tomorrow ? Please post what you have tried.
1 Like 1 ·
Shwe avatar image
Shwe answered
SELECT EmployeeID, Last_Name, First_Name from EMployee_Table WHERE Employee_D IN (SELECT Distinct EmployeeID from Employee where OrderDate <= '1998-05-01' )
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Tiff5282 avatar image
Tiff5282 answered
USE Northwind GO SELECT Employees.LastName, Employees.FirstName, Employees.EmployeeID, Orders.OrderDate FROM Employees INNER JOIN Orders ON Employees.EmployeeID = Orders.EmployeeID WHERE OrderDate <= '1998-05-01'
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.