Join two tables with two or three same field

[eluser]Anil3a[/eluser]
Got it .... i just Solved it myself.

Code:

$this->db->select('*');
$this->db->from('gift');
$this->db->join('transact', 'transact.transact= gift.gift_id');
$query = $this->db->get();
return $query->result();

While joining table, the same name of field doesn't matter but must a field should match same to join .... is it.

I think its the answer.