Magento join select multiple columns


Magento join select multiple columns : You can select multiple columns as below.


Example of magento join select multiple columns

You can select multiple columns in magento joins as below:

//load collection 
$collection = Mage::getModel('module/model_name')->getCollection();
$collection->getSelect()->join('table2'=>'table2_to_be_joined','main_table.table_field ='table2.table2_field',array('table2.field_name1','table2.field_name2','main_table.field_name1','main_table.field_name2','main_table.field_name3'));

You can use table alias to select columns as above.


User Ans/Comments

📖 Read More


Advertisements