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

92 votes175 views6 answers
Turn python script into exe
Python
0 vote177 views1 answer
Insertar en una lista anidada python
Python
3 votes183 views1 answer
Change plot size matplotlib python
Python
42 votes185 views3 answers
Df iterrows pandas
Python
0 vote202 views1 answer
Csrf token fetch django
Python
82 votes178 views6 answers
How to create a for loop in python
Python
0 vote173 views1 answer
Int and text on same line python
Python
0 vote211 views1 answer
Inherit functions from other classes
Python
3 votes205 views1 answer
Default argument in flask route
Python Flask
-1 vote197 views1 answer
Python scatterplot figsize
Python