Join with Sum

Reebo · #1 (**permalink**) 12-22-03, 09:06

Hello, I've got a trouble on the simple DB2 operation. I have two tables:

Code:

Gift
===================
id id_employee
1  1
2  2
3  4

Amount
===================
id id_employee amount
1  1                 10
2  1                 20
3  2                 15
4  5                 45

How can I get a LEFT JOIN with summing the amounts. I need something like:

Code:

Result
===================
id id_employee amount
1  1                 30
2  2                 15
3  4                 0                <- important

I hope it is easily done. Thx!

dmmac · #2 (**permalink**) 12-22-03, 09:25

Here's a way:

select g.id, g.employee, SUM(a.amount) amount
from gift g
left outer join amount a on g.employee = a.employee
group by g.id, g.employee

Quote:

Originally posted by Reebo
Hello, I've got a trouble on the simple DB2 operation. I have two tables:

Code:

Gift
===================
id id_employee
1  1
2  2
3  4

Amount
===================
id id_employee amount
1  1                 10
2  1                 20
3  2                 15
4  5                 45

How can I get a LEFT JOIN with summing the amounts. I need something like:

Code:

Result
===================
id id_employee amount
1  1                 30
2  2                 15
3  4                 0                <- important

I hope it is easily done. Thx!

Internet Services

Web Development

Digital Marketing

Consumer Tech