When should I use CROSS APPLY over INNER JOIN? When should I use CROSS APPLY over INNER JOIN? sql sql