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 vote173 views1 answer
Customizable TKinter Buttons Python
Python
0 vote175 views1 answer
Df = df.apply(lambda x: np.square(x) if x.name in [ 'a', 'e', 'g'] else x, axis=1)
Python
5 votes154 views1 answer
Check django object exists
Python
0 vote154 views1 answer
Highlight Active Links in Django Website
Python
3 votes177 views2 answers
Python multiply list by scalar
Python
14 votes203 views5 answers
How to import modules in python
Python
-1 vote212 views2 answers
Python increment
Python
0 vote178 views1 answer
Randian angle to degrees using numpy
Python
0 vote221 views1 answer
Black python
Python
0 vote156 views1 answer
How to get the realpath with python
Python