Join two tables with two or three same field

[eluser]Anak Indonesia[/eluser]
$this->db->select('*');
$this->db->from('gift');
$this->db->join('trans', 'trans.trans_id = gift.gift_id');
$this->db->where_not_in('gift.gift_id', $trans_ids);
$query = $this->db->get();