SET DELETED is scoped to the current datasession. Make sure set it's ON in the datasession you're running your query in. DELETED() doesn't work with multitable selects. It's documented in the help.

>Hello. I'm trying to perform a LEFT OUTER JOIN where the right table has some deleted records. I want my query results to be as if those deleted records weren't in the file at all(hey-- that's why I deleted them, after all!). DELETED() doesn't work, and the SELECT statement doesn't respected the "SET DELETED" setting. Is there any way other than creating an lDeleted column in all my tables and updating and checking it every time I do this? Please LMK. Thanks.