以下是产品(PRODUCT)表和供应商(SUPPLIER)表的结构:
PRODUCT
-----------
PRODUCT_ID NUMBER
PRODUCT_NAMEVARCHAR2(25)
SUPPLIER_IDNUMBER
CATEGORY_IDNUMBER
QTY_PER_UNITNUMBER
UNIT_PRICE NUMBER(7, 2)
QTY_IN_STOCKNUMBER
QTY_ON_ORDERNUMBER
REORDER_LEVEL NUMBER
SUPPLIER
------------
SUPPLIER_IDNUMBER
SUPPLIER_NAME VARCHAR2(25)
ADDRESS
VARCHAR2(30)
CITY
VARCHAR2(25)
REGION
VARCHAR2(10)
POSTAL_CODE
VARCHAR2(11)
要求创建一个查询,这个查询将以字母顺序返回产品的清单,其中包括了每个产品的供应商。要求只有在产品表中有供应商的那些产品才可以包括在清单(报告)中。请问使用以下的哪两个查询能完成此项查询A.SELECT p.product_name, s.supplier_name
FROM product p
LEFT OUTER JOIN supplier s
ON p.supplier_id=s.supplier_id
ORDER BY p.product_name;
B.SELECT p.product_name, s.supplier_name
FROM product P
JOIN supplier s
ON (supplier_id)
ORDER BY p.product_name;
C.SELECT p.product_name, s.supplier_name
FROM product p
NATURAL JOIN supplier s
ORDER BY p.product_name;
D.SELECT p.product_name, s.supplier_name
FROM product p
JOIN supplier s
USING (p.supplier_id)
ORDER BY p.product_name;
E.SELECT product_name, supplier_name
FROM product
JOIN supplier
USING (supplier_id)
ORDER BY p.product_name;