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 vote336 views2 answers
Connect to mysql database jupyter
Python
5 votes326 views2 answers
Allauth django
Python
2 votes338 views2 answers
Choice random word in python from a text file
Python
0 vote341 views1 answer
Two input string sum in django
Python
0 vote258 views1 answer
Python program to combine each line from first file with the corresponding line in second file
Python
2 votes346 views2 answers
Python Decompress gzip File
Python
0 vote342 views1 answer
Django model registration
Python
0 vote335 views1 answer
How to separate year from datetime column in python
Python
-1 vote369 views2 answers
Python timestamp to yyyy-mm-dd
Python
0 vote324 views1 answer
Django require_POST body
Python