以下是PRODUCT表和SHIPPING COST表的结构:
PRODUCT
---------------------------------
PRODUCT_ID NUMBER(9)
PRODUCT_NAMEVARCHAR2(20)
COSTNUMBER(5, 2)
RETAIL_PRICENUMBER(5, 2)
WEIGHT NUMBER(5, 2)
SHIPPING_COST
---------------------------------
ID NUMBER(9)
LOWWEIGHT NUMBER(5, 2)
HIGHWEIGHT NUMBER(5, 2)
COSTNUMBER(5, 2)
如果需要显示包括了每个产品运输价格(shipping cost)的产品名(product name),而运输价格是通过比较SHIPPING COST表中产品重量的下限和上限来计算的。现在请问,应使用如下查询语句中的哪两个语句
A.SELECT
product_name, cost
FROM
product NATURAL JOIN shipping_cost;
B.SELECT
p.product_name, s.cost
FROM
product p, shipping_cost s
WHERE
p.product_id=s.id(+);
C.SELECT
p.product_name, s.cost
FROM
product p, shipping_cost s
WHERE
p.weight BETWEEN s.lowweight AND s.highweight;
D.SELECT
p.product_name, s.cost
FROM
product p, shipping_cost s
USING
(p.weight, BETWEEN s.lowweight AND s.highweight);
E.SELECT
p.product name.s.cost
FROM
product p JOIN shipping_cost s
ON
(p.weight BETWEEN s.lowweight AND s.highweight);