内部联接在cakephp中不起作用

Question

i have two tables in my database salaries model is Salary and userdetais model is Userdetail in which i want to fetch result bye comparing id and user_id code is

$this->Salary->find('all',
  array(
      'joins'=>array(
      'table'=>'erp_userdetails',
      'alias' => 'Userdetail',
      'type' => 'INNER',
      'conditions' => array('Salary.user_id' => 'userdetail.id')
       )
     )
  );

Answer 1

Try this

this->Salary->find('all',
            array('joins'=>
                    array(
                        array('table'=>'erp_userdetails',
                              'alias' => 'Userdetail',
                              'type' => 'INNER',
                              'conditions' => array('Salary.user_id' => 'userdetail.id')
                        )
                    )
                )
        );