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 vote147 views2 answers
Python def example
Python
16 votes108 views4 answers
Tqdm library
Python
5 votes148 views2 answers
Finding the format of an image in cv2
Python
0 vote144 views1 answer
Api to find information about superheros
Python
0 vote147 views1 answer
Python pandas convert comma separated number string to integer list
Python
0 vote141 views1 answer
Renomear colunas pandas
Python
0 vote157 views6 answers
Python converter to c
Python
69 votes157 views3 answers
Reverse the words in a string python
Python
0 vote149 views3 answers
Dataframe row print
Python
0 vote153 views1 answer
Python check if hotkey pressed
Python