Is it possible???

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 Received on Thu Nov 04 2004 - 15:34:21 CST