I have two tables:
QuoteID, Customer Fields
Quote, Status, DateCreated Fields
I would presume that I need to join these two tables where (QuoteID = Quote). I'm only interested in Quotes where the Status = Value (i.e. Status = 'In Shipping'). Since the History table contains a complete history of all status records, I only want the most recent status, based off the date field 'DateCreated'.
How do I write this sql query. All attempts thus far have returned zero results.