>One question dough, didn't you mean SELECT *LAST* APP_DATETIME,APP_SERVICEID ?

Oops, sorry, ignore my above question. You certainly meant FIRST as you wrote down, since you've a descending key on the APP_DATETIME column.

>Is this pure SQL code? Or a special FireBird thing?

Thanks, Tom.



[Non-text portions of this message have been removed]