Hi,
I have 2 tables:
- Ord
- Ord_Load
I need to be able to create a report per
LOAD_ID from ORD_LOAD table and per DEST_ID from ORD table.
Each DEST_ID can have multiple orders in ID column and each ID has an early_del and a late_del date and time.
I need to pull per load ID and destination ID what is the minimum early_del and the maximun late_del date and time among the orders from each stops
How can I do this?
You will find in attachment the 2 tables + what should be the final result.
Thanks for your help.
Table-extract-and-final-result.xlsx
Try this:
Open in new window