84669 person learning
152542 person learning
20005 person learning
5487 person learning
7821 person learning
359900 person learning
3350 person learning
180660 person learning
48569 person learning
18603 person learning
40936 person learning
1549 person learning
1183 person learning
32909 person learning
现有两个表格,表格1 ->T1:id name time type1 A hh 12 B kk 13 c vv 2表格2-> T2:id pid every1 1 202 1 103 1 54 2 155 2 106 3 257 3 35其中表格2的pid关联表格1的id,当type=1时,希望得到如下两条数据:1 A hh 20+10+5(35)2 B kk 15+10 (25)求教sql语句该怎么写啊,谢谢!PS:用的是thinkPHP框架
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;