SELECT
V.V_CONTACT, V.V_PHONE
FROM
VENDOR AS V,
PRODUCT AS P
WHERE
P.P_CODE = 'P1' AND
V.V_CODE = P.V_CODE;
views:
39answers:
1
+3
A:
SELECT
V.V_CONTACT, V.V_PHONE
FROM
VENDOR AS V
JOIN PRODUCT AS P ON V.V_CODE = P.V_CODE
WHERE
P.P_CODE = 'P1';
Mitch Wheat
2009-09-19 05:12:04