title: Yii Joined table but not all selected data is retrieved
body: <p>I have the following criteria in my controller.</p>
  
  <pre><code>    $criteria = new CDbCriteria;
      $criteria-&gt;select = 't.*,b.*,c.*';
      $criteria-&gt;join = "INNER JOIN tbl_patient_chair b ON b.patient = '0005'
                          INNER JOIN tbl_chair c ON b.chair = c.Serial_No";
      $criteria-&gt;condition = "t.client_id = '0005'";
  
      $model = Patient::model()-&gt;findAll($criteria);
  
      $this-&gt;render('view', array(
          'model' =&gt; $model
      ));
  </code></pre>
  
  <p>Then in my view I am trying to retrieve all the selected data by doing:</p>
  
  <pre><code>foreach ($model as $models)
    print_r($model);
  </code></pre>
  
  <p>But in the result I can see that there is no data from second and third table. The data of the first table is successfully retrieved however I cannot display the other table's data.</p>
  
  <p>Can anyone tell me what I am doing wrong?</p>