CREATE VIEW LargeOrderShippers

AS

SELECT S.CompanyName, O.OrderID, O.Freight

FROM Shippers AS S

INNER JOIN Orders AS O ON (S.ShipperID = O.ShipVia)

GO

select S.*

from freight_manager M

INNER JOIN LargeOrderShippers S ON O.Freight >=M.min_value AND O.Freight <=M.max_value