>
>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
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.