title: CDBCriteria for Custom Cgridview
body: <p>I do not fully know yii framework. How to make CDbCriteria for cases like this?
  I have a basic query code like this.</p>
  
  <pre><code>SELECT
  jam_kerja.id,
  jam_kerja.id_cabang,
  jam_kerja.tgl_berlaku,
  jam_kerja_detail.id_jam_kerja,
  jam_kerja_detail.shift,
  jam_kerja_detail.jamkerja,
  jam_kerja_detail.jamistirahat
  FROM
  jam_kerja ,
  jam_kerja_detail
  WHERE
  jam_kerja_detail.id_jam_kerja =  jam_kerja.id and  jam_kerja.id_cabang=5
  </code></pre>
  
  <p>Maybe there Yii friends who can help me?</p>