Question

请允许我帮助我:

我有一个表格:

1: Users
id   username   email
1    myname     [email protected]
2    myname2    [email protected]

2: Accounts
user_id   account
1         37992054
2         3804933 
1         23286966

我需要提出请求并获得这一数据:

id   username   email                account
1    myname     [email protected]    37992054, 23286966
2    myname2    [email protected]   3804933

Answer 1

您需要加入您的两张表格,并使用一种组合式建筑,以便与同样的用户id倒记录:

Select u.id, u.username, u.email, group_concat(a.account)
from users as u join accounts as a 
  on a.user_id = u.id
group by u.id;

Answer 2

你们需要一个标准的共同点:

select u.id,u.username,u.email,a.account from Users as u, Accounts as a where u.id=a.id;

友情链接