cakephp containable condition problem
    /*assume the following tables: businesses_locations (location_state_id), users_locations(location_state_id), and businesses_reviews(user_id, business_id). How should a 'find' call on BusinessesReview look like in order to select only those entries where the user state DIFFERS from the business state?
     
    */
    $this->BusinessesReview->contain(array('BusinessesProfile'=>array('BusinessesLocation'),'User'=>array('UsersLocation')));
            $results = $this->BusinessesReview->find('all', array('conditions'=>array('BusinessesLocation.location_state_id <> UsersLocation.location_state_id')));
     
    //gives error:
    MySQL Error: 1054: Unknown column 'BusinessesLocation.location_state_id' 
cakephp containable condition problem
===

    /*assume the following tables: businesses_locations (location_state_id), users_locations(location_state_id), and businesses_reviews(user_id, business_id). How should a 'find' call on BusinessesReview look like in order to select only those entries where the user state DIFFERS from the business state?
     
    */
    $this->BusinessesReview->contain(array('BusinessesProfile'=>array('BusinessesLocation'),'User'=>array('UsersLocation')));
            $results = $this->BusinessesReview->find('all', array('conditions'=>array('BusinessesLocation.location_state_id <> UsersLocation.location_state_id')));
     
    //gives error:
    MySQL Error: 1054: Unknown column 'BusinessesLocation.location_state_id' 