Welcome Guest, Not a member yet? Register   Sign In
Matching data from 2 table with validation date
#1

(This post was last modified: 02-06-2019, 01:08 PM by DELE.)

At this time I have data from the database, results of the join data table users and table campaigns, like this :

ID
001
005
008

and I have data from table incomes, like this :

id       name      date
1        001        2018-10-10
2        005        2018-10-10
3        008        2018-10-10
4        001        2018-10-11

how to check the results of the join data in table incomes?

if the data ID is not the same as the data name on 2018-10-11, the results will be obtained :

ID
005
008

The question: what query should I use and what method do I need to apply in the controller / view. if the masters here are willing to include with simple code it is very very valuable to me.

thank you, greetings coding.
Reply


Messages In This Thread
Matching data from 2 table with validation date - by DELE - 02-06-2019, 12:50 PM



Theme © iAndrew 2016 - Forum software by © MyBB