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 vote202 views1 answer
How to find root value python
Python
0 vote193 views1 answer
Remove last line of text file python
Python
60 votes232 views4 answers
Csv python write
Python
2 votes210 views2 answers
Check multiple keys in python dict
Python
22 votes187 views6 answers
Python strings
Python
0 vote216 views3 answers
Move window with overrideredirect
Python
1 vote200 views1 answer
How to count down in python using turtle graphics
Python
0 vote186 views1 answer
Change one value based on another value in pandas
Python
0 vote198 views1 answer
Multigreading sys.exit does not work
Python
65 votes216 views4 answers
Python randomize list
Python