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 vote158 views1 answer
Prefetched_related django rest framework
Python
0 vote150 views4 answers
Dataframe to dict without index
Python
0 vote137 views1 answer
Turtle python screen border
Python
2 votes148 views2 answers
For j in range(1,10,-1):
Python
0 vote183 views1 answer
Truncatechars django
Python Django
1 vote139 views1 answer
Python condition if dataype
Python
2 votes160 views2 answers
Pandas replace null values with values from another column
Python
0 vote299 views1 answer
Flask extends two base.html
Python
0 vote134 views2 answers
Discord.py send message to channel with mutiple id
Python
0 vote174 views1 answer
Python tuples number Multiplication
Python