Question: what is the difference between inner join and cross apply in sql server?
Answer: The CROSS APPLY operator is semantically similar to INNER JOIN. ... This is similar to the INNER JOIN operation performed on the Author and Book tables. CROSS APPLY returns only those records from a physical table where there are matching rows in the output of the table valued function.