search

Home  >  Q&A  >  body text

mysql - sql query problem

There are two tables (only used to represent structures)

  1. 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

过去多啦不再A梦过去多啦不再A梦2840 days ago633

reply all(3)I'll reply

  • phpcn_u1582

    phpcn_u15822017-05-18 10:52:35

    select name,sum(num) from A inner join B on A.code =B.code group by name

    reply
    0
  • 某草草

    某草草2017-05-18 10:52:35

    SELECT SUM(num) FROM 2 WHERE code IN (SELECT code FROM 1 WHERE name = 1)

    reply
    0
  • 習慣沉默

    習慣沉默2017-05-18 10:52:35

    select 2.num from 1 inner join 2 2 on 2.code=1.code

    reply
    0
  • Cancelreply