sql - Inner join and cross apply. How does it get evaluated? -

if inner join is: each row in left table, find row in right table condition met.

what's cross apply? have read it's inner join gets evaluated row row, isn't inner join evaluated row row?

how explain cross apply in plain english? inner join allows more complicated joins?

apply different join in allows correlated subqueries. instance:

select ... outer apply (   select ..   inner outer.column = inner.column )  

at first not seems of difference, until consider relational functions. since apply accepts correlations other side, means can pass values arguments function:

select ... outer apply function(outer.column)  

this not possible join.

the cross vs. outer same joins'.