Magento: join with magento collection

Hi friends, I this article we will discuss how to use join in magento. The magento worked on collections based on module. A collection is a Model type containing other Models.In this example we will use getCollection() method to load event collection.

Also Checkout other tutorial of Magento Collection,

We can create collection array based on below code:

We can get database table with help of below code:

Now we have collection and table where we want add join, so below code will create LEFT JOIN with ‘event type’ table.

after above code, we have collection which has data based on our join criteria. Now with help of below code we can fetch all data from collections.

Full Code of join with magento collection: