title: Magento - Add zip code / postcode to the order grid in Magento 1.6.2
body: <p>I am trying to get the order grid to display the postcode/ zip code of the of the customer.</p>
  
  <p>I am trying to join the sales_flat_order_address alias with the collection but to no success.</p>
  
  <pre><code>protected function _prepareCollection() {
      $collection = Mage::getResourceModel($this-&gt;_getCollectionClass());
     $collection-&gt;getSelect()-&gt;join('sales_flat_order_address', 'main_table.entity_id = sales_flat_order_address.parent_id',array('postcode'));
    //var_dump($collection);
      $this-&gt;setCollection($collection);
      return parent::_prepareCollection();
  }
  </code></pre>
  
  <p>Can any one please help me figure out a solution for this.</p>