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 vote327 views1 answer
Mechanize python #10
Python
0 vote284 views1 answer
?: (admin.W411) 'django.template.context_processors.request' must be enabled in DjangoTemplates (TEMPLATES) in order to use the admin navigation sidebar.
Python
2 votes272 views1 answer
Open image in numpy
Python
0 vote289 views1 answer
Reportlab page size a4
Python
1 vote300 views1 answer
F string python not working in linux
Python
1 vote290 views1 answer
Wxpython make window stay on top
Python
81 votes292 views6 answers
Check python version
Python
0 vote446 views1 answer
Flask request file push request(uploadedfile= request.file) uploadedfile.read()
Python Flask
1 vote303 views1 answer
Dashes seaborn
Python
0 vote267 views1 answer
Radice n esima python
Python