Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> 2nd try
Hi,
I have two table, one is containing a dated list of delivery to do and the second contain a list of delivery done.
ex: Table 1 --> Order No, Delivery date requested, Quantity requested Table 2 --> Shipping No. Order No. Date shipped Quantity shipped
They are not into the same list because there is no one on one relation between those two list (ex: some delivery might have been back order, or that might have been some over shipment, etc...)
The QUESTION:
what query can I do to known where am I at in my delivery schedule?
What I would like is something like a list with
Delivery date requested Quantity requested Quantity shipped
The only that I can see of how to do it, it's to write a function that will figure out how much have been shipped for each delivery, but this cause heavy overhead.
Another way of looking at it would be:
but then sum on the left side of a test is not permitted
So, I'm stuck, I do not know how to proceed
Thanks Received on Fri Nov 05 2004 - 14:53:55 CST
![]() |
![]() |