tags:

views:

39

answers:

1
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;
+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