Skill 2.1 Query data by using subqueries and APPLY

Question 1

What is the difference between CROSS APPLY and OUTER APPLY

Answer 1

The CROSS APPLY operator returns only those rows from left table expression (in its final output) if it matches with right table expression. In other words, the right table expression returns rows for left table expression match only. Whereas the OUTER APPLY operator returns all the rows from left table expression irrespective of its match with the right table expression.