select distinct s.CompanyName,c.CategoryName,p.ProductName from Products p
inner join Categories c on c.CategoryID=p.CategoryID
inner join Suppliers s on s.SupplierID=p.SupplierID
inner join [Order Details] od on od.ProductID=p.ProductID
inner join Orders o on o.OrderID=od.OrderID
where o.OrderDate between '01-01-1997' and '31-12-1997' 
and s.Fax  is not null
order by c.CategoryName