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

7 votes180 views4 answers
Python tkinter button multiple commands
Python
0 vote177 views2 answers
Shotgun api filter
Python
0 vote207 views2 answers
Import static
Python
0 vote171 views1 answer
Tensor.numpy() pytorch gpu
Python
0 vote166 views1 answer
Ya mom
Python
0 vote179 views1 answer
Replace string if it contains a substring pandas
Python
2 votes174 views1 answer
Comparing file content in python
Python
14 votes183 views5 answers
Discord py get user by id
Python
0 vote176 views1 answer
How to clear console in repl.it python
Python
0 vote172 views1 answer
Matplotlib overlapping labels
Python