Need Help With SQL Query for Oracle RDB

I am trying to write a query that combines data from 2 different tables.

Table 1: POWERON
HEATNUMBER   BUCKETSEQUENCENO   CONSUMPTION  
 981011                      1                                   31  
 981011                      1                                  1269  
 981011                      1                                  15062  
 981011                      2                                  20327  
 981011                      3                                  577  
 981011                      3                                  36689  

Table 2: BUCKETS_HEAT
 HEAT_NUMBER   BUCKET_SEQUENCE   MATWEIGHTACT1   MATWEIGHTACT2  
 981011                      1                                          24150           20250  
 981011                      2                                          20100           30200  
 981011                      3                                          20050           20000

My goal is to get total CONSUMPTION and total weight (MATWEIGHTACT1 + MATWEIGHTACT2) for each BUCKET_SEQUENCE.

Here is my query:
SELECT B.HEATNUMBER, B.BUCKET_SEQUENCE,
sum(B.MATWEIGHTACT1 + B.MATWEIGHTACT2) as TOTAL_METALLIC_WEIGHT,
sum(P.CONSUMPTION) as POWER_CONSUMED
from BUCKETS_HEAT B, POWERON P
where
B.HEATNUMBER = P.HEATNUMBER
and B.BUCKET_SEQUENCE = P.BUCKET_SEQUENCE
group by B.HEATNUMBER, B.BUCKET_SEQUENCE, P.HEATNUMBER, P.BUCKET_SEQUENCE order by B.HEATNUMBER, B.BUCKETSEQUENCE;

This is the result:
 HEAT_NUMBER   BUCKET_SEQUENCE   TOTAL_METALLIC_WEIGHT         POWER_CONSUMED  
 981011                      1                                                      133200                  16362  
 981011                      2                                                        50300                  20327  
 981011                      3                                                         80100                 37266  

Here is whay I found:
POWER_CONSUMED for all 3 rows is correct.
Row 1 TOTAL_METTALIC_WEIGHT is 3X too large (Table POWERON has 3 records for BUCKET_SEQUENCE = 1).
Row 2 is correct (1 to 1 match in tables for BUCKET_SEQUENCE = 2).
Row 3 TOTAL_METALLIC_WEIGHT is 2X too large (Table POWERON has 2 records for BUCKET_SEQUENCE = 3).

Any suggestions?
Start Free Trial