Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Is it possible???
On Thu, 04 Nov 2004 21:39:31 GMT, Bricklen <bricklen_at_zyahoo.zcomz>
wrote:
>Patrice Béliveau wrote:
>> 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?
>>
>> Thanks
>what is your question?
>How many deliveries you've done? what's the most recent delivery done?
>what is the nearest (min) date of a delivery yet to do? How many
>deliveries yet to do?
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 Received on Fri Nov 05 2004 - 07:20:57 CST