title: Select a field without `e.` or `main_table` - Magento
body: <p>This question follows from one of my other questions on this forum. I have created a custom module and have overridden 'Review' model's core files. It allows me to save data to my custom field 'email' fine. But when I try to retrieve the values of this field, it doesn't recognize my field at all.</p>
  
  <p>This is my query, </p>
  
  <pre><code>Mage::getModel('review/review')-&gt;getCollection()
  -&gt;addFieldToFilter('status_id' , '1')
  -&gt;addFieldToFilter('email', $emailId)
  -&gt;addFieldToSelect('email');
  </code></pre>
  
  <p>And this is what I get when I echo it,</p>
  
  <pre><code> SELECT `main_table`.`email` AS `review_detail`, `detail`.`detail_id`, `detail`.`title`, `detail`.`detail`, `detail`.`nickname`, `detail`.`customer_id` FROM `review` AS `main_table` INNER JOIN `review_detail` AS `detail` ON main_table.review_id = detail.review_id WHERE (status_id = '1') AND (email = 'test@test.com')
  </code></pre>
  
  <p>Its obviously trying to select email from <code>main_table</code> which is <code>review</code> table instead of <code>review_detail</code> table. Is there a way to select <code>email</code> field without <code>main_table</code> prefix or just change the query such that it selects <code>email</code> from <code>review_detail</code> table?</p>
  
  <p>Please help me out. I have come across posts related to <code>joins</code> but not sure if that is one of the options in my case or not. Thanks in advance.</p>