Search code examples
phpcodeigniteractiverecord

Cross join in codeigniter?


I'm trying this

$this->db->join('tableTwo as b','','CROSS');
$result = $this->db->get('tableOne as a')->result(); 

Some solution?


Solution

  • Solution for cross join in codeigniter:

    $this->db->join('tableTwo as b','true');
    $result = $this->db->get('tableOne as a')->result();