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

1 vote212 views2 answers
Turn off colorbar seaborn heatmap
Python
7 votes162 views3 answers
How to get all possible combinations in python
Python
0 vote162 views1 answer
Comentar codigo en python
Python
0 vote174 views1 answer
ConversionofDatatypes-I
Python
8 votes156 views2 answers
New dataframe based on certain row conditions
Python
0 vote155 views2 answers
Python decimal remove trailing zero
Python
0 vote155 views1 answer
Defaultdict count key value pairs
Python
1 vote157 views1 answer
Id() python
Python
5 votes147 views2 answers
TypeError: sequence item 0: expected str instance, int found
Python
0 vote204 views1 answer
Import "sendgrid" could not be resolved django
Python Django