Never heard of "Apply" before.

Nice to know that "The difference between join and APPLY operator becomes evident when you have a table-valued expression on the right side and you want this table-valued expression to be evaluated for each row from the left table expression"

Learn something again.

Thanks!