SELECT p.ProductID, p.ProductName, p.CategoryID, p.QuantityPerUnit, p.UnitPrice, p.UnitsInStock, s.CompanyName FROM Products p, Suppliers s WHERE p.SupplierID = s.SupplierID ORDER BY ProductName