I have a custom table
user_product_table with a field
sku(this field join to product collection) and
user. How can I join this table with product collection, so that I don't have to loop my custom collection to get product in each row.
$userCollection = $this->_userProductFactory->create() ->getCollection() ->addFieldToFilter('user', 2);
My product Collection:
$productColelction = $this->_productCollectionFactory->create() ->addAttributeToSelect(array('name','image','short_description','sku'))
I would like to have final collection both my custom table fields and selected product attributes.