[Solved] What is the difference between OUTER APPLY and OUTER JOIN, and when to use each? [closed]
First, I do not really know which is the default OUTER JOIN in T-SQL (I’d bet FULL), but in any case, I think it is unclear – it is best to use LEFT, RIGHT, OR FULL JOIN explicitly when you need one. JOIN joins tables. Already existent ones or subqueries. APPLY applies (duh) a table-valued … Read more