Solved

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;

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions