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

0 vote244 views1 answer
Import tsv as dataframe python
Python
0 vote242 views1 answer
Push to pypi
Python
2 votes221 views3 answers
Scatter plot actual vs predicted python
Python
3 votes217 views2 answers
How to check if text is in upper case in python
Python
0 vote193 views1 answer
Lower case of string
Python
0 vote195 views1 answer
How to encode a string in python
Python
0 vote210 views1 answer
Line plot python only years datetime index
Python
1 vote297 views2 answers
Management command in django
Python Django
0 vote198 views1 answer
Sum() function in Python
Python
0 vote244 views1 answer
Pip ne marche pas
Python