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 vote381 views1 answer
Mediapipe python face landmarks
Python
0 vote365 views1 answer
Mak a scipy csr sparse matrix
Python
35 votes327 views6 answers
Python for loop range
Python
1 vote334 views1 answer
Python append several values
Python
53 votes350 views3 answers
Python publishing exe
Python
2 votes306 views3 answers
Set axis ticks matplotlib
Python
0 vote344 views1 answer
Django multi column index
Python
2 votes333 views1 answer
Django load model by name
Python
4 votes344 views2 answers
Pandas replace values with only whitespace to null
Python
1 vote333 views1 answer
Accept user input in python
Python