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.vendorid = pv2.vendorid
AND pv1.productnumber<>pv2.productnumber
ORDER BY productname;