这样连接product_unit_price RIGHT OUTER JOIN
requisition ON product_unit_price.product_id = requisition.product_id
and requisition.order_number between product_unit_price.lowerbound and product_unit_price.upperbound如果再客户端输入时查询product_unit_price RIGHT OUTER JOIN
requisition ON product_unit_price.product_id = requisition.product_id
and 输入的数量 between product_unit_price.lowerbound and product_unit_price.upperbound
requisition ON product_unit_price.product_id = requisition.product_id
and requisition.order_number between product_unit_price.lowerbound and product_unit_price.upperbound如果再客户端输入时查询product_unit_price RIGHT OUTER JOIN
requisition ON product_unit_price.product_id = requisition.product_id
and 输入的数量 between product_unit_price.lowerbound and product_unit_price.upperbound
set @input=2500select [unit_price]
from product_unit_price
where
[lowerbound]<=@input and [upperbound]>=@input
@ID CHAR(12)set @input=20select [unit_price]
from product_unit_price
where
product_id = @ID AND
[lowerbound]<=@input and [upperbound]>=@input