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.