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

2 votes254 views5 answers
Django documentation
Python Django
0 vote246 views1 answer
Python min length list of strings
Python
0 vote296 views1 answer
Extends template django file system
Python Django
0 vote244 views1 answer
Python save base64 temp file
Python
0 vote253 views1 answer
Python sys environment
Python
57 votes221 views6 answers
Int to string python
Python
0 vote235 views1 answer
List Join 2 Lists
Python
0 vote224 views1 answer
Use an async check function for discord.py wait_for?
Python
0 vote267 views1 answer
Fibonci in python
Python
0 vote237 views1 answer
How to copy content of one file to another in python
Python