Join Indexes and the WITH DELETED ROWS Option
You cannot include join indexes in the SELECT statement when you specify the WITH DELETED ROWS option.
You cannot include join indexes in the SELECT statement when you specify the WITH DELETED ROWS option.