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

7 votes203 views3 answers
Build a discord bot to delete messages python
Python
0 vote261 views1 answer
Table pandas to postgresql
Python
1 vote265 views1 answer
Calculate Euclidean Distance in Python using distance.euclidean()
Python
7 votes265 views4 answers
Keras
Python
0 vote255 views3 answers
Convert c code to python code online
Python
0 vote250 views1 answer
Extract label from tf data
Python
8 votes280 views3 answers
Django order by
Python Django
0 vote249 views1 answer
Strategy forex with python
Python
7 votes199 views1 answer
Dataframe count null values
Python
0 vote291 views1 answer
Python show charracter code
Python