reterview data from two tables using inner join in cakephp
        Posted  
        
            by 
                user3593884
            
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by user3593884
        
        
        
        Published on 2014-06-01T15:22:43Z
        Indexed on 
            2014/06/01
            15:24 UTC
        
        
        Read the original article
        Hit count: 189
        
I two tables from database one as user(id,first_name,last_name) and the second table location(id,country). I need to perform inner join with this two tables and the list should display first_name,last_name,country with condition user.id=location.id I have written sql queries in cakephp
 $this->set('users',$this->User->find('list', array(
                'fields' => array('User.id', 'User.first_name','location.country'),
                array('joins' => array(array('table' => 'location',
                               'alias' => 'location',
                               'type' => 'INNER',
                               'conditions' => array('User.id = location.id')))))));
i get error -Unknown column 'location.country' in 'field list' Please help!
© Stack Overflow or respective owner