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 vote180 views1 answer
How to accept invalidfileexception in python
Python
0 vote173 views1 answer
IsADirectoryError: [Errno 21] Is a directory: '/'
Python
2 votes179 views2 answers
Instance variable python
Python
19 votes176 views2 answers
How to check datatype of column in dataframe python
Python
0 vote181 views1 answer
Pop element from heap python
Python
3 votes175 views1 answer
Delete element from list value
Python
0 vote203 views1 answer
Running mean
Python
0 vote147 views1 answer
Histogram matplotliub
Python
0 vote178 views2 answers
Address already in use
Python
0 vote182 views1 answer
Remove or drop rows and columns with null values
Python