I am trying to use a derived table as part of a query in informix. I am tring to show the maximum date from it.
I keep getting error messages, which are not helpful i.e. Unknown error message number '-201'
(select casact.caseid, max(casact.activity_date)
from arista01:student1.casact casact
group by casact.caseid) a
Does anybody know the correct syntax for the above query?