I have stored country id in my custom table. How to join the my custom collection with country collection to get a Country Name.
I have tried below code but its not working :
$collection = Mage::getModel('XXX/XXX')->getCollection()->addFieldToSelect(array('city','country_id')); $collection->getSelect()->join( array('second'=>$collection->getTable('directory/country')), 'main_table.country_id = second.code', array('second.name') )->getData();
Hope someone will provide some useful information.