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

1 vote201 views1 answer
How to set the size of a gui in python
Python
0 vote260 views1 answer
Matplotlib FiveThirtyEight creating a signature
Python
13 votes265 views6 answers
Online python compiler for GUI
Python
0 vote243 views1 answer
Install sorting
Python
0 vote258 views1 answer
Python discord if == emoji not working
Python
3 votes317 views1 answer
Default argument in flask route
Python Flask
4 votes267 views3 answers
Django Change Password
Python
0 vote253 views1 answer
How to send image to template thats not in static flask
Python
4 votes274 views2 answers
Mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
Python
2 votes258 views1 answer
Check whether number is even or odd
Python