Matching data from 2 table with validation date

@DELE,

I prefer to use the query bindings feature ( https://www.codeigniter.com/userguide3/d...y-bindings ).   This gives me more flexibility to write my own queries and the binding feature automatically escapes the variables for me.  So my code would look like...

PHP Code:

$sql = "select ucj.id
from users_campaigns_join_view ucj
inner join incomes i on i.id = ucj.id
where i.date = ?";

$this->db->query($sql, ['2018-10-10']);