php - 交叉加入codeigniter？

Question

我正在尝试这个

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

一些解决方案？

Answer 1

codeigniter中cross join的解决方法:

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