Magento 2 Join Product Collection with Custom CollectionFactory

Question

In Magento 2.2.5, I have Custom Model Collection (followed this tutorial).

In that I want to add the Product Collection into this custom collection by default. How to achieve this.

Answer 1

You can override

Magento\Catalog\Model\ResourceModel\Product\Collection class and join your custom collection with using _initSelect() function

Example:

protected function _initSelect()
{
    $this->getSelect()->joinRight(['secondTable' => $this->getTable('custom_table')],'secondTable.id = main_table.entity_id');
    return $this;
}