* With a single source table you can ... CREATE CURSOR TT ( AA I) APPEND BLANK APPEND BLANK DELETE APPEND BLANK SET DELETED OFF SELECT DELETED() AS isDeleted,RECNO() FROM TT && WHERE ... * With multiple source tables you must reduce the query context to one, with a derivate subquery ... SELECT X.isDeleted,... FROM (SELECT DELETED() AS isDeleted,... FROM TT) X JOIN ...