selecting data from 2 tables

[eluser]toopay[/eluser]
Use sub-query instead...

Code:

$query = $this->db->where('constituency_id', $id)
                  ->where('elect_year', $elect_year)
                  ->where('candidate_votes','(SELECT MAX(candidate_votes)FROM candidate_details)')
                  ->get('candidate_details');

Huh. Too much code here, not the right section for that. Next time, post your similar thread under 'CodeIgniter Core' or 'CodeIgniter Reactor' section, okay.