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

4 votes140 views2 answers
Python thread pool
Python
2 votes159 views2 answers
Ticks font size matplotlib
Python
0 vote170 views1 answer
Python : read all the lines of the text file and return them as a list of strings (use of 'with open')
Python
4 votes146 views2 answers
Mode code python
Python
5 votes159 views6 answers
Delete a file from git history
Python
-1 vote148 views2 answers
Shell script to convert yaml
Python
0 vote291 views1 answer
Django force download file
Python Django
0 vote157 views1 answer
Python requests insecure request warning
Python
-1 vote172 views1 answer
Post an image Flask
Python Flask
0 vote139 views1 answer
Check if number is divisible without remainder python
Python