Help With Join

[eluser]Faisal Alghamdi[/eluser]
it will be easy with active record and something like this. ..

Code:

$this->db->select('*');
   $this->db->select_avg('SALARY');
   $this->db->from('main_records');   $this->db->where('main_records.approval',1);  
   $this->db->join('names', 'names.idnm = main_rs.idnm','left');
   $this->db->join('ages', 'ages.idEXPERIENCE = main_records.idEXPERIENCE','left');
   $this->db->group_by('CITY');
   $this->db->order_by('SALARY','asc');
   $q = $this->db->get();
return $q->result();

using active records is the best way in terms of debugging the code.