USE northwind
SELECT * FROM
Categories cate INNER JOIN Products p ON cate.CategoryID=p.CategoryID
LEFT OUTER JOIN [ORDER Details] od ON od.ProductID=p.ProductID
LEFT OUTER JOIN Orders o ON o.OrderID=od.OrderID
WHERE YEAR(o.OrderDate) = 2000