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 votes237 views3 answers
Pair plot python
Python
18 votes178 views1 answer
Pandas read txt
Python
36 votes166 views10 answers
Python list keys from dictionary
Python
0 vote224 views1 answer
Python json web request
Python
0 vote261 views1 answer
How to deploy to heroku djangorest framework app
Python Django
0 vote218 views1 answer
Adding column to CSV Dictreader
Python
0 vote216 views1 answer
Python set table widget header
Python
0 vote233 views1 answer
Django fixtures. To loaddata
Python Django
28 votes209 views2 answers
For i in range step python
Python
2 votes198 views2 answers
Or operator django
Python