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

13 votes94 views3 answers
Django form example
Python
0 vote91 views1 answer
Python sqlobject declare connection
Python
0 vote97 views1 answer
Linux echo redirect output to python script
Python
2 votes131 views2 answers
Print( n ) in python
Python
0 vote93 views1 answer
Return object in python
Python
0 vote152 views1 answer
Python community
Python
0 vote143 views1 answer
Python codes for counting the occurrence of a letters in dictionary excluding digits
Python
0 vote163 views1 answer
Adam optimizer keras learning rate degrade
Python
0 vote138 views1 answer
Python sort list alpha
Python
0 vote101 views1 answer
Where to import messages in django
Python