Hi techies,

There is a new issue here about MySQL GROUP_CONCAT() function.

when i try to use the group_concat() function's result value with IN() Condition, i am not getting expected result set. Please find the ex given below.

eg.
SELECT dept_id, dept_name FROM dept_id
WHERE dept_id IN(SELECT GROUP_CONCAT(emp_dept_id) FROM emp_table)

This query is working but in the where condition, say for example the subquery returns (10,20,30,50) means it takes only the first value (10).

If any one come across this issue please reply the solution...

__________________
Keep smiling...