• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Matching data from 2 table with validation date

#1
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

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.