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 ____.
SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT, V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE => VENDOR.V_CODE;
WHERE PRODUCT.V_CODE <=>=>
WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
WHERE PRODUCT.V_CODE <> VENDOR.V_CODE;
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here