I have 2 tables:
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.