请问我用的mysql数据库,A表:
UserID UserName
1 name1
2 name2B表:
ID UserID Point
1 1 10
2 1 12
3 1 15
4 2 9
5 2 15我想查出的结果是:
UserID UserName Points
1 name1 10 12 15
2 name2 9 15
怎么查询,请高手指点,谢谢!
UserID UserName
1 name1
2 name2B表:
ID UserID Point
1 1 10
2 1 12
3 1 15
4 2 9
5 2 15我想查出的结果是:
UserID UserName Points
1 name1 10 12 15
2 name2 9 15
怎么查询,请高手指点,谢谢!
SELECT B.UserID ,A.UserName,GROUP_CONCAT(Point) AS PointS FROM B INNER JOIN A ON B.UserID=A.UserID
GROUP BY B.UserID ,A.UserName
from a,b
where a.UserID=b.UserID
group by a.UserID