多选题 以下是产品(PRODUCT)表和供应商(SUPPLIER)表的结构：
PRODUCT
-----------
PRODUCT_ID NUMBER
PRODUCT_NAME VARCHAR2(25)
SUPPLIER_ID NUMBER
CATEGORY_ID NUMBER
QTY_PER_UNIT NUMBER
UNIT_PRICE NUMBER(7, 2)
QTY_IN_STOCK NUMBER
QTY_ON_ORDER NUMBER
REORDER_LEVEL NUMBER
SUPPLIER
------------
SUPPLIER_ID NUMBER
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;