There are two tables (only used to represent structures)
name code
1 --------1
1 --------2
1 --------3
2----------5
2----------4
2.
code num
1------ -2
2 ------ 3
3------ 4
4-------5
5--------6
I want to get data like name-----sum(num)
Please give me some advice
phpcn_u15822017-05-18 10:52:35
select name,sum(num) from A inner join B on A.code =B.code group by name
某草草2017-05-18 10:52:35
SELECT SUM(num) FROM 2 WHERE code IN (SELECT code FROM 1 WHERE name = 1)