INNER JOIN vs. CROSS APPLY | EXPLAIN EXTENDED
From Stack Overflow: Can anyone give me a good example of when CROSS APPLY makes a difference in those cases where INNER JOIN will work as well? This is of course SQL Server. A quick reminder on the terms. INNER JOIN is the most used construct in SQL ......