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 vote111 views1 answer
Add values to pandas plot
Python
1 vote124 views1 answer
Can you print to multiple output files python
Python
0 vote108 views1 answer
Python minimal app
Python
0 vote114 views1 answer
Why python stops after plt.show()
Python
0 vote112 views1 answer
Django vs code extensions
Python
0 vote121 views1 answer
Python keyboard monitoring
Python
0 vote118 views1 answer
Read image and resize
Python
0 vote120 views1 answer
How to replace the file if the file already exist in google drive api in python
Python
92 votes121 views6 answers
Python choose random element from list
Python
1 vote100 views1 answer
How to set screen brightness automatically depending on battery percentage using python
Python