title: Propel and symfony : Join Table doesn't work
body: <p>Firstly I explain  my issue : </p>
  
  <p>I have two tables Job and JobCategory :</p>
  
  <pre><code>job:
     -------------------------------------------------
     | id   | category_job_id | job_name  | keywords  |
     -------------------------------------------------
  
  JobCategory: 
    -------------------------
    | id   | categoty_name  |
    -------------------------
  </code></pre>
  
  <p>tho two tables is related by foreign key "category_job_id".</p>
  
  <p>In this application I'm using Propel ORM. I hoped to make search using three fields keywords, job_name and category_name.</p>
  
  <p>The first field is keywords is "input" who I can write keywords, the second field is Category_name is a "select", list of category. The third field is Job_name and is a "select", list of Job name, and if is not empty the keywords fields will be ignored.</p>
  
  <p>I make function of search like this, but it doesn't work for me:</p>
  
  <pre><code>  public function searchFilter($job,$category,$keyword)
     {
  
  $order = isset($this-&gt;order) ? $this-&gt;order : Criteria::ASC;
  
  $job = '%' .$job. '%';
  $category = '%' .$category. '%';
  
  $c = new Criteria();
  
  $c-&gt;addJoin(JobPeer::CATEGORY_JOB_ID, JobCategoryPeer::ID);
  if((null !== $category) AND ($category !== ""))
  {
   $c-&gt;addOr(JobCategoryPeer::CATEGORY_NAME,$category, Criteria::LIKE);    
  }
  if((null !== $job) AND ($job !== ""))
  {
   $c-&gt;addOr(JobPeer::JOB_NAME,$job, Criteria::LIKE);   
  }
  
  $query = JobQuery::create(null, $c)
          -&gt;joinWith('Job.JobCategory')
          -&gt;orderByDateOfJob($order);
  
    if((null !== $keyword) AND ($keyword !== "")){
      $keyword = '%' .$keyword. '%';
      $query-&gt;filterByKeywords($keyword, Criteria::LIKE);
    }      
  
  $results = $query-&gt;find();
  
  
  return $results;
  
  }
  </code></pre>
  
  <p>But the search is all cases is wrong!</p>