SELECT a.vendorid FROM Products a LEFT JOIN ProductsCategories b ON a.ProductID = b.ProductID WHERE b.CategoryID = #categoryID# GROUP BY a.vendorid SELECT * FROM Vendors WHERE VendorID in (#valueList(vendorsList.vendorid)#)

Shop By Brand