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

13 votes184 views2 answers
How to copy one dictionary to another in python
Python
0 vote191 views1 answer
How to get count by using group by in python
Python
0 vote193 views1 answer
How to remove duplicate files from folder with python
Python
1 vote171 views2 answers
How to get elasticsearch index list using python
Python
7 votes212 views1 answer
Python xrange
Python
0 vote179 views1 answer
Get the time of 1 minute later in python
Python
1 vote175 views1 answer
Make csv lowercase python
Python
0 vote206 views1 answer
Django command to fetch all columns of a table
Python
0 vote178 views1 answer
Pandas assign value to row based on condition
Python
5 votes192 views4 answers
Python save dictionary to file
Python