Marc,

I misunderstood your question. The grandparent thing threw me.

If there was a one to one relationship between HAWB and Shipments, then the query that you outlined works. However, since there isn't, I think that the following gets what you need:

select Hawb, sum(Value), sum(Charge);
from shipment,charges;
where charges.shipment = shipment.shipment;
order by hawb, shipment.shipment;
group by hawb, shipment.shipment

BTW, You're the first one to even remotely reference my signature line.

hth,

George