Hello all, ok I am going to explain this the best I can. I have a table called TransactionType. In this table I have the following fields and example records:
TransactionID TransationType TransactionDate CustomerID
1 File Upload 11/17/2008 1
2 Check-Out 11/18/2008 1
3 Check-In 11/19/2008 1
4 Check-Out 11/20/2008 1
So what I need to do is based on the MAX TransactionID for each customer, I need to check if the latest record is = Check-Out. So this means I need to skip past the File Upload record here. So I need to get a resultset of customerid where there last transactionid was check-out and not check-in ignoring anything like File Upload. I hope this makes sense. So in this case I would get 1 in my resultset but if Check-In was id 4 then it would not.