Oracle SQL: Add sum from another table to query results

Question

I have two tables where one of the tables, TABLE2, has a column for TABLE1_IDs, thus there is a many-to-one relationship between TABLE2 and TABLE1 rows. TABLE2 has a column PRICE which is a number that represents a dollar amount. I have a query that obtains certain rows of TABLE1, but I want to get the total of all corresponding TABLE2 rows' PRICE values as an additional column in the query results.

How do I accomplish this in Oracle?

have you tried SQL? it is pretty cool :)

MarianP
– MarianP

2011-08-12 20:56:17 +00:00
Commented Aug 12, 2011 at 20:56 — MarianP
– MarianP, Commented Aug 12, 2011 at 20:56
Yeah this should be pretty easy for someone who knows SQL.

Muhd
– Muhd

2011-08-12 20:57:54 +00:00
Commented Aug 12, 2011 at 20:57 — Muhd
– Muhd, Commented Aug 12, 2011 at 20:57

Datajam · Accepted Answer · 2011-08-12 21:02:20Z

4

Easy - join, and sum.

select t1.table1_id
,      sum(t2.price) total_price
from   table1 t1
,      table2 t2
where  t1.table1_id = t2.table1_id
group  by t1.table1_id;

answered Aug 12, 2011 at 21:02

Datajam

4,2612 gold badges25 silver badges25 bronze badges

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

Comments

Lamak · Accepted Answer · 2011-08-12 21:03:50Z

3

I believe you want something like this:

SELECT A.Id, SUM(B.Price) TotalPrice
FROM (  SELECT *
        FROM Table1
        WHERE Something) A
LEFT JOIN Table2 B
ON A.Id = B.Table1_id
GROUP BY A.Id

answered Aug 12, 2011 at 21:03

Lamak

70.8k12 gold badges119 silver badges119 bronze badges

Collectives™ on Stack Overflow

Oracle SQL: Add sum from another table to query results

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related