Hi all,

Is there a way to speed the following query up?

SELECT APP_DATETIME as LAST_APPOINTMENT, APP_SERVICEID as LAST_SERVICEID
FROM APPOINTMENTS APP1
WHERE APP_DATETIME = (SELECT MAX(APP_DATETIME)
FROM APPOINTMENTS APP2
WHERE (APP2.APP_INVITEDID = :PersonID) AND (APP1.APP_INVITEDID= :PersonID))

Or is there another, better way to find the same information

Thanks in advance,
Tom.


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