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 vote215 views1 answer
Label_map dict = label_map_util.get_label_map_dict(label_map)
Python
1 vote205 views2 answers
Making a basic network scanner using python
Python
21 votes197 views5 answers
No module named cv2
Python
0 vote183 views1 answer
How to make python script run forever
Python
5 votes193 views1 answer
Python leap year solution
Python
0 vote199 views1 answer
Cv2 get framerete video
Python
0 vote212 views2 answers
Groupby fillna ffill
Python
0 vote200 views1 answer
Paschat opposite sanskrit
Python
1 vote197 views1 answer
Python trick big numbers visualisation
Python
4 votes186 views1 answer
Python remove duplicates words from string
Python