Even though most queries which use CROSS APPLY can be rewritten using an INNER JOIN, CROSS Implement can yield improved execution strategy and greater efficiency, as it can limit the set being joined but ahead of the join happens. +----+-------------+--------------------+------------+-------+-------------------------------------------------+--------------------------------------------... https://books-about-illumaniti58998.blogdanica.com/37092013/examine-this-report-on-how-to-join-an-outlaw-motorcycle-club-book