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

question 23

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 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;
• B)SELECT P_DESCRIPT,P_PRICE,V_NAME,V_CONTACT,V_AREACODE,V_PHONE FROM PRODUCT,VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
• C)SELECT P_DESCRIPT,P_PRICE,V_NAME,V_CONTACT,V_AREACODE,V_PHONE FROM PRODUCT,VENDOR WHERE PRODUCT.V_CODE <= VENDOR.V_CODE;
• D)SELECT P_DESCRIPT,P_PRICE,V_NAME,V_CONTACT,V_AREACODE,V_PHONE FROM PRODUCT,VENDOR WHERE PRODUCT.V_CODE => VENDOR.V_CODE;