The best replacement for cross apply is inner join.

The best alternatives to cross apply are rated as following:
★★★★★  inner join
★★★★  outer apply
★★★  unpivot
★★  left outer join
★★  join
★★  correlated subquery
★★  cte
★  scalar function
★  row_number
★  cross join

Your alternative for cross apply is not listed? Suggest!


No companions for cross apply have been suggested so far.
You have in mind a companion for cross apply and it is not yet here? Propose!



Google Trends

Scale is based on the average worldwide traffic of cross apply in all years. Click on graph for more.
cross apply
inner join
outer apply