asdad

use Northwind;

select distinct Employees.EmployeeID, Employees.LastName, Categories.CategoryName
from Employees, Orders, [Order Details], Products, Categories where
Categories.CategoryName = 'Beverages' AND Products.CategoryID = Categories.CategoryID
AND [Order Details].ProductID = Products.ProductID AND [Order Details].OrderID = Orders.OrderID
AND Orders.EmployeeID = Employees.EmployeeID