APPLY

Part1 - https://www.navicat.com/en/company/aboutus/blog/1783-understanding-sql-server-cross-apply-and-outer-apply-queries-part

Part2 - https://www.navicat.com/en/company/aboutus/blog/1795-understanding-sql-server-cross-apply-and-outer-apply-queries-part-2