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 vote186 views1 answer
Tuples as return values
Python
15 votes178 views5 answers
Check empty dataframe
Python
11 votes195 views2 answers
Format python number with commas
Python
1 vote235 views1 answer
Tuple with one element python
Python
5 votes266 views3 answers
Sys module in python
Python
8 votes198 views3 answers
Python csv add row
Python
1 vote186 views1 answer
Python screen recorder
Python
13 votes198 views1 answer
Root bg tkinter
Python
0 vote192 views1 answer
Python subtract to minimum 0
Python
9 votes178 views4 answers
Scikit learn random forest
Python