Matching data from 2 table with validation date |
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. |
Messages In This Thread |
Matching data from 2 table with validation date - by DELE - 02-06-2019, 12:50 PM
RE: Matching data from 2 table with validation date - by php_rocs - 02-06-2019, 07:45 PM
RE: Matching data from 2 table with validation date - by DELE - 02-07-2019, 03:40 PM
RE: Matching data from 2 table with validation date - by php_rocs - 02-07-2019, 04:35 PM
RE: Matching data from 2 table with validation date - by DELE - 02-08-2019, 08:31 AM
RE: Matching data from 2 table with validation date - by php_rocs - 02-08-2019, 08:43 AM
RE: Matching data from 2 table with validation date - by DELE - 02-08-2019, 09:14 AM
RE: Matching data from 2 table with validation date - by php_rocs - 02-08-2019, 09:19 AM
RE: Matching data from 2 table with validation date - by DELE - 02-09-2019, 08:25 AM
|