title: how can i display the result of two tables in gridview display yii
body: <p>I have two tables Table A and Table B.</p>
  
  <p>I have the pk of table A ,as fk called member_id in table B.</p>
  
  <p>While girdview display of table B, I want to show the "Member name" in table A, using the "member_id" in table B.</p>
  
  <pre><code>$this-&gt;widget('zii.widgets.grid.CGridView', array(
  'id'=&gt;'transaction-grid',
  'dataProvider'=&gt;$model-&gt;search(),
  'filter'=&gt;$model,
  'columns'=&gt;array(
      'id',
      'member_id',
      'Location',
      ...
      array(
          'class'=&gt;'CButtonColumn',
          'template'=&gt;'{view}',
      ),
  ),
  )); 
  </code></pre>