title: How to write the query in yii,using findAll()
body: <p>I have the following sql query, how can I write the query in yii  using <code>findAll()</code>?</p>
  
  <p>I am not using <code>CDbCriteria</code> and for the time being avoiding it.</p>
  
  <p>Using three tables user, category and job_profile.</p>
  
  <pre><code>SELECT * 
  FROM job_profile
  INNER JOIN user ON user.id = job_profile.user_id
  INNER JOIN category ON category.id = job_profile.category_id
  WHERE category_id = 1
    AND experience = 2
    AND key_skills LIKE  '%php%'
  </code></pre>
  
  <p>I have written the following queries but I do not know how to include join:</p>
  
  <pre><code> $results = SearchEmployee::model()-&gt;findAll("category_id=:category AND key_skills like 
  :skill AND experience=:experience", array(
              'category'=&gt;$category,
              'skill'=&gt;'%'.$skills.'%',
              'experience'=&gt;$experience
              ));        
  </code></pre>