我有两张桌子:
原文链接:/javaschema/281964.html我想编写返回我的查询:
姓名,地址列表(地址1,地址2,地址3,..)
就像是:
Select A.name,B.list_of_addresses From Names A Inner Join (Select name_id,/*list_of_addresses with comma between them*/ From Addresses Group By name_id) B ON A.id=B.name_id