SELECT DISTINCT P.PRODUCTNAME, PV1.VENDORID
FROM PRODUCTS P INNER JOIN PRODUCT_VENDORS PV1 ON P.PRODUCTNUMBER = PV1.PRODUCTNUMBER
INNER JOIN PRODUCT_VENDORS PV2 ON PV1.PRODUCTNUMBER = PV2.PRODUCTNUMBER
AND PV1.VENDORID<>PV2.VENDORID
ORDER BY P.PRODUCTNAME;