title: Get ProductName using Collection Magento
body: <p>I've a list of product Ids and based on that product Id I want to get product Name but as the catalog_product_entity table doesn't contain the product name only sku, I'm trapped.</p>
  
  <p>kindly check my code, I've tried left and right join both but not getting the name</p>
  
  <pre><code>$collection = Mage::getModel('catalog/product')-&gt;getCollection()
      -&gt;addAttributeToSelect('name')
      -&gt;getSelect()-&gt;joinRight( 
          array('table_alias'=&gt;'my_table'), 
          'entity_id = table_alias.product_id',
          array('table_alias.*')
      );
  
  $result = null;
  
  foreach ($collection as $temp) {    
      $result[] = array(
          'name' =&gt; $temp-&gt;getCustomer_name(),               
      );
  }   
  </code></pre>