获取另一个表的值

The first table is like this:-

LocalityID | LocalityName | StateID | LocalityChamp

 1         |     anyName  |    1    |  AnYOne

The second table is like this :-

StateID | StateName

  1     |   anyState

I want to return the values like this

1    anyName      anyState    AnYOne

in codeignitor

Assuming that first table name is locality and second table name is state. Use the following query

SELECT Locality.LocalityID , Locality.LocalityName, State.StateName from locality 
inner join State on State.StateID=Locality.StateID

or use Active Records .

Edit

In your model create a function like this;

function getChamps() {
 $this->db->select('Locality.LocalityID , Locality.LocalityName, State.StateName');
 $this->db->from('Locality');
 $this->db->join('State', 'State.StateID = Locality.StateID');
 $query = $this->db->get();
 return $query->result_array();
}

In your controller

function index()
{
 $data['Champs']=$this->Model_name->getChamps();
 $this->load->view('path/to/view',$data);
}