OK Cetin,
First, let me tell you how much I appreciate the assistance. This SQL is above my pay grade.

We are soooo close. Obviously I have not been clear enough.

You are getting the latest OPEN transaction per inmate. That's helpful but not exactly what I need.

Inmate 0012345 should not show in the cursor. Why? His latest transaction is a "CLOSED". Only the inmates where the latest transaction is an "OPEN" should show in the cursor. So what I am after is a list of inmates that are currently OPEN.

Having said all that, I could be doing something wrong. Please correct me if I am.
Thanks,
John