I have read other threads on this topic, but I haven't found anything that works for me. I have a table that stores comments for orders. There are many notes for each order and I want to select the newest comment for each order so I can have a list of all orders with their last update.
Example Table (orders):
Order Comment# Note
12345 100 Parts on order
98765 300 Shipped today
12345 200 Sent UPS blue
98765 900 Received parts
Desired Output:
Order Comment# Note
12345 200 Sent UPS blue
98765 900 Received parts
Thank you for your help.