Sub Query Return More Than Row

[amit_patel]

Hello all,
I want to know is it possible to return more than one column result in single row? for example
suppose i have two table master table and child table , child table contain more than one result from the parent table id show when i make query for master table then in single row i want all the result from child table using comma or something else

Please reply me asap

Thanks and regards,
---Amit patel

[bogu]

mysql GROUP_CONCAT