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 vote134 views1 answer
Find width and height of imported video frame opencv2
Python
0 vote135 views1 answer
Python split string into floats
Python
11 votes140 views4 answers
Invert a dictionary python
Python
0 vote131 views1 answer
Crontab python
Python
0 vote134 views2 answers
Dataframe change specicf values in column
Python
0 vote130 views1 answer
How to split a string with newline in python
Python
2 votes140 views1 answer
Pandas find top 10 values in column
Python
1 vote126 views1 answer
How to make a use of list in python to make your own length function
Python
2 votes136 views1 answer
Truncate templat tag django
Python
0 vote135 views1 answer
Waiting in python. time , sleep
Python