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