>>>
>>>select Hawb, sum(Value), sum(Charge);
>>>from shipment,charges;
>>>where charges.shipment = shipment.shipment;
>>>order by hawb, shipment.shipment;
>>>group by hawb, shipment.shipment
>>>
>>
>>George! This will give me totals by shipment, not by HAWB. Keep telling you, there _is_ no way to do this in one SQL.
>>
>>>BTW, You're the first one to even remotely reference my signature line.
>>>
>>
>>Hmm. Are you sure that it is me you have in mind. I swear I passed my master, and no, Disraeli is not even a far cousin ... :)
>>
>>Now, if you allude to my data definitions, then I sympathise with you. Life must be miserable, if you hate data definitions in this line of business:)
>>
>>I do like your signature though, in fact I like all your quotations, and I still think you have the CD online :).
>>
>>Kind regards,
>>
>>Marc
>
>Marc,
>
>I'm assuming that the output for this is a report, perhaps that's where I miss the boat. However, if we're out to sea, rather than "up the creek", then this will still work in the form of a summary report. Just group by HAWB, and sum in the report. Admittedly, this may not be the best solution, but, hey, if it works...well, at least we've got a paddle.
>
>Still no CD here at the office. Actually, I got that quote out of an ancient document, my high school year book. I added the bit about C/S students, because it seemed to apply. I had a professor that took two weeks simply defining things in my first class in second year C/S.
>
>Best wishes,
>
>George
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.