>>No, you can not use a DELETED('alias') reference in a SQL select statement. You can use a DELETED()
reference as long as there is only one table involved in the SELECT.
SELECT * FROM junk WHERE DELETED('junk')
will return no records, even if there are records marked for delete, where:
SELECT * FROM junk WHERE DELETED()
will return deleted records.<<

You missed something here. When you use this statement, always bear in your mind that 'DELETED' value int the environment is set to 'OFF'. Better read the 'SET DELETED' statement. Since you tried my tricked and failed, then try again by issuing the 'SET DELE ON' statement before the SQL-STATEMENT.