As you certainly know, we can often replace a JOIN with an APPLY, but this will not always lead to the same execution plan. Let us look at this