\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ #tables: t_doctors t_location id,name doc_id,address -------- --------------- 1,jack 1, street1 2,duh 1, street2 1, street3 2, str1 2, str2 2, str3 \\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\ # Result Required id,name,location 1,jack,"street1,street2,street3" 2,duh,"str1,str2,str3"