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 vote100 views2 answers
Periodogram
Python
4 votes99 views3 answers
Formatting strings in python
Python
25 votes106 views4 answers
Pandas count the number of unique values in a column
Python
8 votes101 views2 answers
How to check whether input is string or not
Python
0 vote103 views1 answer
Subprocess the system cannot find the file specifie
Python
6 votes109 views1 answer
Python append a file and read
Python
0 vote102 views1 answer
Don't Get Volunteered!
Python
0 vote96 views1 answer
How to find a website ip address
Python
0 vote105 views1 answer
How to get the percentage accuracy of a model in python
Python
0 vote126 views1 answer
Pyqt graph
Python