The query to join the P_DESCRIPT and P_PRICE columns from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE and V_CONTACT columns from the VENDOR table, where the values of V_CODE match and the...



The query to join the P_DESCRIPT and P_PRICE columns from the PRODUCT table and the V_NAME, V_AREACODE, V_PHONE and V_CONTACT columns from the VENDOR table, where the values of V_CODE match and the output is ordered by the price is ____.









a.



SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE


      FROM PRODUCT, VENDOR


              WHERE PRODUCT.V_CODE => VENDOR.V_CODE;


ORDER BY P_PRICE;







b.



SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE


      FROM PRODUCT, VENDOR


              WHERE PRODUCT.V_CODE <=>


ORDER BY P_PRICE;







c.



SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE


      FROM PRODUCT, VENDOR


              WHERE PRODUCT.V_CODE = VENDOR.V_CODE;


ORDER BY P_PRICE;







d.



SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE


      FROM PRODUCT, VENDOR


              WHERE PRODUCT.V_CODE <> VENDOR.V_CODE;


ORDER BY P_PRICE;





Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here