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

10 votes206 views1 answer
Python turtle
Python
4 votes207 views1 answer
Django include
Python
0 vote198 views1 answer
Pandas columns starting with
Python
0 vote188 views1 answer
Drop a list of index pandas
Python
40 votes187 views2 answers
Sorting values in dictionary in python
Python
0 vote191 views1 answer
How to add legend on side of the chart python
Python
0 vote196 views1 answer
Pandas df count values less than 0
Python
23 votes181 views1 answer
Python year month from date
Python
0 vote192 views2 answers
Get the first item from an iterable that matches a condition
Python
4 votes199 views1 answer
Pandas transpose
Python