I am running a query with two tables:
1. Historical table of status codes and date status code changed.
2. Dataset of records.
I want to return only the records that have are currently sitting at an O status and exclude them if they have an S status..
Example:
Record 12345 was on O status on 03/13/2009 and changed to an S status on 06/26/2010... If it changed to an S status, I want to exclude that record from my dataset.
What criteria would be used to accomplish this?