What is the difference between OUTER APPLY and INNER JOIN on Sql Server?

Navigation
1

What is the difference between OUTER APPLY and INNER JOIN in Sql Server ?

I know how LEFT/RIGHT/INNER JOIN works however I came across OUTER APPLY I gave a read but I did not completely understand, it seems to be a% open% type where I could do an internal subselect acting as a INNER JOIN normal. Would it be this? Or have more things about?

Furthermore what would performance compare with?

    
asked by anonymous 22.09.2015 / 01:23

1 answer

1

An OUTER APPLY will return null fields in which there is no match. While the Inner join does not return, it only returns values in which there is matching. Null values are not returned.

Without being a rule, I use a lot of apply operators when I need to invoke a call to a function.

I hope I have helped.

    
13.10.2015 / 19:54
JPA Error with Wildfly - No Persistence provider for EntityManager named Project Set field to null - CodeIgniter