The Query to Join the P_DESCRIPT and P_PRICE Fields from the PRODUCT

Multiple Choice

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

A) SELECT PRODUCT.P_DESCRIPT,PRODUCT.P_PRICE,VENDOR.V_NAME,VENDOR.V_CONTACT,VENDOR.V_AREACODE,VENDOR.V_PHONE FROM PRODUCT,VENDOR
WHERE PRODUCT.V_CODE <> VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;
B) SELECT PRODUCT.P_DESCRIPT,PRODUCT.P_PRICE,VENDOR.V_NAME,VENDOR.V_CONTACT,VENDOR.V_AREACODE,VENDOR.V_PHONE FROM PRODUCT,VENDOR
WHERE PRODUCT.V_CODE => VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;
C) SELECT PRODUCT.P_DESCRIPT,PRODUCT.P_PRICE,VENDOR.V_NAME,VENDOR.V_CONTACT,VENDOR.V_AREACODE,VENDOR.V_PHONE FROM PRODUCT,VENDOR
WHERE PRODUCT.V_CODE <= VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;
D) SELECT PRODUCT.P_DESCRIPT,PRODUCT.P_PRICE,VENDOR.V_NAME,VENDOR.V_CONTACT, VENDOR.V_AREACODE,VENDOR.V_PHONE FROM PRODUCT,VENDOR
WHERE PRODUCT.V_CODE = VENDOR.V_CODE; ORDER BY PRODUCT.P_PRICE;