Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement