If i have a product collection in a multi store environment and i wish to also retrieve a specific attributes value from another store with my collection result, how is the best way to do this?
For example, i have english, french and german store.
Each product has a custom attribute, called company_description. I want to be able to be able to get the collection from one store but also retrieve the company_description as it is set in the other 2 store views also.
It needs a join but i dont how best to do the manual eav joining.
// In english store context $productCollection = Mage::getModel('catalog/product')->getCollection()->addAttributeToSelect('company_description');
I then need to do something with a join so i can get all 3 descriptions as:
company_description company_description_fr company_description_de