現(xiàn)有兩個(gè)表格，表格1 ->T1：
id name time type
1 A hh 1
2 B kk 1
3 c vv 2
表格2-> T2：
id pid every
1 1 20
2 1 10
3 1 5
4 2 15
5 2 10
6 3 25
7 3 35
其中表格2的pid關(guān)聯(lián)表格1的id,當(dāng)type=1時(shí)，希望得到如下兩條數(shù)據(jù)：
1 A hh 20+10+5（35）
2 B kk 15+10 (25)
求教sql語句該怎么寫啊，謝謝！PS:用的是thinkPHP框架
2
0
0
select t1.id, t1.name, t1.time, sum(t2.every)
from t1
inner join t2 on t1.id=t2.pid
group by t1.id, t1.name, t1.time
SELECT T1.id,T1.name,T1.time,SUM(T2.every)
FROM T1
INNER JOIN T2 ON T1.id = T2.pid
GROUP BY T1.id;
![[Web-Frontend] Node.js-Schnellstart](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
