Matching data from 2 table with validation date

@DELE,

You need to determine what join you want (https://www.cloudways.com/blog/wp-conten...ysql-1.png )

This might work for you...

select ucj.id
from users_campaigns_join ucj
inner join incomes i on i.id = ucj.id
where i.date = '2018-10-10'

from users_campaigns_join ucj // this is not a table but results from a combination of user tables and campaign tables, are you sure this way?