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 vote277 views2 answers
Print specific key in dictionary python
Python
1 vote275 views1 answer
Color name to hex python
Python
0 vote294 views2 answers
Labs fill ggplot2
Python
0 vote257 views1 answer
How to make code only go once python
Python
2 votes261 views2 answers
Instagram private account hacking code python
Python
4 votes275 views3 answers
How to get a character from a string in python
Python
0 vote281 views1 answer
Pyaduio linux
Python
43 votes302 views2 answers
Write python program to take command line arguments (word count).
Python
30 votes266 views5 answers
Colab mount drive
Python
0 vote272 views1 answer
How to add previous and next in tkinter in python
Python