I am trying to access the
tbl_destinations that holds all the numbers. And field
destinations has the comma separated ID like
1,3. but according to this query i just get the the result of id
1 i didn't get the result of id
SELECT count( id ) AS totalDestination, group_concat( ring_to_number ) AS phoneNumbers FROM tbl_destinations WHERE id IN ( SELECT destinations FROM tbl_rings_to_groups WHERE id = '1' AND user_id = '1' )
Can anyone please tell me why i didn't get the
1,3 in SubQuery?