I have a query that checks the order number of two tables. I am trying to determine the status what is the last status by date.
Example
Table 1
Order number 12345
Order start date 10/3/19 10:00 am
Order status: in progress
Order number 12345
Order start date 10/4/19 11:00 am
Order status: updated
Order number 2222
Order start date 10/4/19
Orders status: open
Table 2
Order number 12345
Order start date 10/3/19 10:15am
Order status: pending
Order number 12345
Order start date 10/5/19 11:00 am
Order status: completed
Order number 2222
Order start date 10/5/19
Orders status: investigate
I want the results to provide me the earliest start date and latest status of the order. So it should compare table 1 which is when I create my orders to Table 2 which is when I began to process them.
I would want it to provide the latest date and latest status.
Bookmarks