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

12 votes359 views5 answers
Pause program python
Python
1 vote379 views1 answer
Python count the frequency of words in a list
Python
0 vote318 views1 answer
Matplotlib add text to axes
Python
0 vote344 views1 answer
Simple click counter in python
Python
0 vote319 views1 answer
Dictionary default value python if key not found
Python
0 vote322 views2 answers
Pyttsx3 save to file
Python
0 vote380 views1 answer
Huesos del cuerpo humano
Python
0 vote317 views1 answer
Tkinter start maximized
Python
156 votes384 views10 answers
Python random
Python
3 votes314 views1 answer
Tensot to numpy pytorch
Python