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

1 vote346 views3 answers
Pandas rename index values
Python
0 vote325 views1 answer
Python webdriver disable logs
Python
0 vote339 views2 answers
Flask abort
Python
0 vote329 views3 answers
Join list with comma python
Python
0 vote364 views1 answer
Read a file line-byline in python
Python
0 vote344 views1 answer
Online convert http query to json python
Python
1 vote391 views1 answer
Keras.layers.MaxPool2D
Python
1 vote362 views2 answers
Python merge pdfs
Python
21 votes424 views2 answers
Getting pi in python
Python
0 vote318 views1 answer
How to subtract numbers in python
Python