database query combine possibility

Hi,

Since you have already written the sql why not just use it like so:

PHP Code:

$this->db->query('YOUR QUERY HERE'); 


For complex queries it is often easier to write an sql query and use is as above.

In the docs: https://www.codeigniter.com/user_guide/d...ml#queries

Best wishes,

Paul.

PS You can also enable the profiler to view the query that was generated which often shows you where it is going wrong.

PHP Code:

$this->output->enable_profiler(TRUE);