Execute the following script in Query Editor to generate product-vendor association:

USE AdventureWorks;

SELECT DISTINCT PRODUCT = P.NAME,
VENDOR = V.NAME
FROM PURCHASING.PRODUCTVENDOR PV1
INNER JOIN PURCHASING.PRODUCTVENDOR PV2
ON PV1.PRODUCTID = PV2.PRODUCTID
AND PV1.VENDORID <> PV2.VENDORID
JOIN PURCHASING.VENDOR V
ON V.VENDORID = PV1.VENDORID
JOIN PRODUCTION.PRODUCT P
ON P.PRODUCTID = PV1.PRODUCTID
ORDER BY PRODUCT, VENDOR