mysql
select 1.lid,1.lname,GROUP_CONCAT(2.sname) from 1 left join 2 on 2.lid=1.lid;
select 1.lid,1.lname,WM_CONCAT(2.sname) from 1 left join 2 on 2.lid=1.lid;
