有两个表:
A(表)
A_id A_content(列)
(如) 1 "A_content1 "
2 "A_content2 "
3 "A_content3 "
. .B(表)
B_id A_id B_Content(列)
(如) 1 1 "B_Content1 "
2 1 "B_Content2 "
3 1 "B_Content3 "
4 2 "B_Content4 "
5 2 "B_Content5 "
6 3 "B_Content6 "
7 3 "B_Content7 "共有字段是A_id
我现在要得到
A_content R_Content(列)
A_content1 B_Content1+B_Content2+B_Content3
A_content2 B_Content4+B_Content5
A_content3 B_Content6+B_Content7这样用查询语句可以实现么?请高手给出SQL语句,感激涕零。请尽量简单一点,复杂的函数语句真的很难看。
A(表)
A_id A_content(列)
(如) 1 "A_content1 "
2 "A_content2 "
3 "A_content3 "
. .B(表)
B_id A_id B_Content(列)
(如) 1 1 "B_Content1 "
2 1 "B_Content2 "
3 1 "B_Content3 "
4 2 "B_Content4 "
5 2 "B_Content5 "
6 3 "B_Content6 "
7 3 "B_Content7 "共有字段是A_id
我现在要得到
A_content R_Content(列)
A_content1 B_Content1+B_Content2+B_Content3
A_content2 B_Content4+B_Content5
A_content3 B_Content6+B_Content7这样用查询语句可以实现么?请高手给出SQL语句,感激涕零。请尽量简单一点,复杂的函数语句真的很难看。
from A inner join B using (A_id)
group by A_content
from A inner join B on A.A_ID=B.A_ID
group by A.A_content;