php - Null result while use and operator in MYSQL IN
This is my query to get filter data from user table where category will fetch from another table.
SELECT * FROM jobfia_users WHERE country_id='4' and user_id IN (SELECT worker_id FROM jobfia_worker_skills WHERE skill_id = '42' )
This is not giving any error, but not return any row also. while there are lots of records are available in table using this filter.
Can any one help please ?