>Hi Sergey,
>Thanks for the input.
>I have attempted to modify as required and this is where I am at. I get the error:
>SQL: Queries of this type are not supported.
>
>SELECT inmates.cid, inmates.cinmate_number, acct_events.tdatetm, acct_events.cstatus ;
> FROM acct_events, inmates;
> WHERE inmates.cid + TTOC(acct_events.tdatetm,1) IN ( ;
> SELECT acct_events.cid + TTOC(MAX(acct_events.tdatetm),1) ;
> FROM acct_events ;
> GROUP BY cid) ;
> INTO CURSOR crsLastEven NOFILTER

Try

SELECT cid, cinmates_id, ttxndatetm, txnstatus ;
  FROM acct_events ;
  WHERE cid + TTOC(ttxndatetm,1) IN ( ;
               SELECT cid + TTOC(MAX(ttxndatetm),1) ;
               FROM acct_events ;
               GROUP BY cid) ;
    AND txnstatus = "OPEN"  ;
  INTO CURSOR LastEvent NOFILTER
SELECT inmates.cid, inmates.cinmate_number, LastEvent.* ;
  FROM inmates ;
    JOIN LastEvent ON LastEvent.cinmates_id = inmates.cid ;
  INTO CURSOR crsResult

You can use < pre > and < /pre > tags (no spaces) to preserve formatting.