>chad,
>cstatus is NOT in the inmates table. It is ONLY in the acct_events table.
>I could put it in the inmates table but that would be redundant data and it would get out of sync and you know the rest of that story.
>John

John,

I posted that before your other post about changing field names for the question. So, was it just a typo or do you still not have the query working?