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

#3
(02-06-2019, 07:45 PM)php_rocs Wrote: @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?
Reply


Messages In This Thread
RE: Matching data from 2 table with validation date - by DELE - 02-07-2019, 03:40 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


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