Relating the two fields into one record

[eluser]Otemu[/eluser]
Hi,

Do your join like this:

Code:

$this->db->join('club as idt1', 'idt1.club = match.team_1');
  $this->db->join('club as idt2', 'idt2.club = match.team_2');

Hope that helps