mysql select columns and sum from other table

Question

I have the following tables:

A: id, name, url
B: Aid, number

number can be any int (Aid is the id from table A)

I want to select the name, url from table A and the SUM(B.number) So the results will be something like:

name, url, SUM(B.number)
name, url, SUM(B.number)
name, url, SUM(B.number)
[..]

I need to join them somehow? How do i construct that query?

Tunaki · Accepted Answer · 2015-11-01 10:07:21Z

3

SELECT name, url, (SELECT SUM(number) FROM B WHERE B.Aid = A.id) As total
FROM A

Tunaki

138k46 gold badges370 silver badges443 bronze badges

answered Nov 1, 2015 at 9:41

Mateo Barahona

1,3918 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

mic4ael · Accepted Answer · 2015-11-01 09:42:59Z

2

SELECT A.name, A.url, SUM(B.number) 
FROM A
LEFT JOIN B ON A.id = B.Aid 
GROUP BY A.name, A.url

Please test it before cause I might have made a mistake since I got no MySQL DB available at the moment.

answered Nov 1, 2015 at 9:42

mic4ael

8,4304 gold badges32 silver badges44 bronze badges