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 vote262 views1 answer
Max path limit python
Python
0 vote334 views1 answer
Else statement python list comprehension
Python
0 vote305 views1 answer
Check date on template django
Python
-1 vote311 views2 answers
Django cleanup
Python
4 votes287 views3 answers
How to input n space separated integers in python
Python
0 vote317 views1 answer
Cube finder python
Python
0 vote304 views1 answer
Changing instance variable python inheritance
Python
0 vote396 views1 answer
Manage.py startapp not working in django
Python Django
0 vote319 views1 answer
Pandas increment value on condition
Python
0 vote315 views1 answer
Mode of a column in df
Python