Magento 2.x – How to easily join tables or models.


With the following snippet, you will be able to join as many tables or models as you want. Bear in mind, that if you are working with a custom model, you should have created the corresponding ResourceModel like this:

Afterwards, and considering that you want to make the join in a block, we will need something like this: