Left join outer apply

--Script #3 - OUTER APPLY and LEFT OUTER JOIN

SELECT * FROM Department D 
OUTER APPLY 
   ( 
   SELECT * FROM Employee E 
   WHERE E.DepartmentID = D.DepartmentID 
   ) A 
GO
 
SELECT * FROM Department D 
LEFT OUTER JOIN Employee E ON D.DepartmentID = E.DepartmentID 
GO

Source: mssqltips.com

Similar codes

11 votes362 views4 answers
Python execute shell command and get output
Python
7 votes358 views3 answers
Delete key value in dictionary python
Python
-4 votes379 views4 answers
Python 3.4 release date
Python
1 vote364 views1 answer
Django queryset multiple filters
Python
4 votes368 views2 answers
Python image to grayscale
Python
0 vote387 views1 answer
David dobrik
Python
0 vote390 views1 answer
Use if a not trusted message will come up
Python
0 vote367 views1 answer
Import symspell
Python
2 votes338 views1 answer
Install telethon
Python
14 votes369 views2 answers
Python check if dictionary empty
Python