Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Is it possible???
"Bricklen" <bricklen_at_zyahoo.zcomz> wrote in message
news:nkxid.76688$df2.35660_at_edtnps89...
| 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?
and, what have you tried so far?
++ mcs Received on Thu Nov 04 2004 - 15:42:50 CST