FIT
100
More Complex Queries and SQL Functions
;
SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT,
V_AREACODE, V_PHONE
FROM PRODUCT, VENDOR
WHERE PRODUCT.V_CODE = VENDOR.V_CODE
AND P_INDATE > 11/15/96;
;
;
SELECT P_DESCRIPT, P_PRICE, V_NAME, V_CONTACT,
V_AREACODE, V_PHONE
FROM PRODUCT A, VENDOR B
WHERE A.V_CODE = B.V_CODE
ORDER BY P_PRICE;