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 vote295 views1 answer
Django pull from Google Sheets
Python
0 vote265 views2 answers
Extra error
Python
0 vote276 views1 answer
Python scheduler
Python
2 votes277 views1 answer
Python class get attribute by name
Python
0 vote276 views1 answer
Django only certain columns from database
Python
2 votes270 views1 answer
Import crypto python
Python
5 votes258 views1 answer
Python check file extension
Python
0 vote288 views3 answers
Get operator as input in python
Python
0 vote314 views2 answers
Python7.blogspot.com=?m
Python
0 vote275 views1 answer
Find & replace in csv file
Python